Dexpro Presents: 
Creating a Date Table Using the Fiscal Period Defined in GP

Belinda Allen

Creating a Date table Using the Fiscal Period Defined in GP

Using the data model from our March meeting for the General Ledger Transactions, we’ll add the Fiscal years tables to the model. With the fiscal year dates, we can create an official date table that will enable the use of Time Intelligence functions using DAX. We’ll be able to create DAX functions like year over year change (by amount and percentage), Year to Date, Rolling Average and Previous Year/Period amounts.
 

Meet the Speaker


Belinda Allen is a Microsoft Most Valuable Professional (MVP) for Power BI. Belinda is currently a Microsoft Power Platform Trainer, Speaker, and the Co-Author of 2 books on Business Intelligence and Microsoft Dynamics GP.


Background

Prior to focusing solely on training, Belinda was a principal at Smith & Allen Consulting, Inc. (SACI) in New York City. SACI was a Microsoft Dynamics GP partner for over 25 years. She has always had a passion for reporting and business intelligence. Her skills include Microsoft SQL Server, Microsoft Power BI, Microsoft Power Apps, Microsoft Power Automate, Microsoft Excel, Microsoft Business Central, and of course Microsoft Dynamics GP.


Power Platform Share on YouTube

Belinda focuses on the Microsoft Power Platform. She happily wears the title #CitizenDeveloper and represents this title in a YouTube Live show (Power Platform Share) that she cohosts with Mariano Gomez and Steve Endow. 

​
Power BI Blogs by Belinda

Belinda is also well known for her blog (Belinda, the GP CSI), and her BI blog (BI Belinda Blog). On her blog, she shares useful information about the product quickly and succinctly. With followers from all over the globe, she can share knowledge and achieve her mission: “To improve the lives and business success of my followers.”

​​

All of Belinda's blogs and notes can be found here.  ​