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

Sign Up for the Power BI Recorded Training

Microsoft Power BI Training for Dynamics GP Users with Belinda Allen, Microsoft MVP.

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.

Check Out a Few of Our Many Locations and Offices Throughout USA

Headquarters

Dexpro Dynamics LLC

100 Pine Street, Suite 1250,

San Francisco, CA 94111

Phone 855-703-4300

628-477-9000

Email info@dexprodynamics.com

Midwest

Dexpro Dynamics LLC

211 W Wacker Dr STE 120, Chicago, IL 60606

Midwest

Dexpro Dynamics LLC

311 Elm Street, Suite 270,

Cincinnati, OH 45202

Central South

Dexpro Dynamics LLC

1910 Pacific Avenue, Suite 2000,

Dallas, TX 75201