In this video, Amelia demonstrates how to create a Fiscal Year Date Table in Power BI using DAX. If your organization operates on a fiscal calendar different from the standard January-December year, this tutorial is essential for you. Follow along as Amelia guides you through the steps to customize your date table to align with your fiscal year.

👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit [ Ссылка ] for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: [ Ссылка ]

🔗Pragmatic Works On-Demand Learning Packages: [ Ссылка ]
🔗Pragmatic Works Boot Camps: [ Ссылка ]
🔗Pragmatic Works Hackathons: [ Ссылка ]
🔗Pragmatic Works Virtual Mentoring: [ Ссылка ]
🔗Pragmatic Works Enterprise Private Training: [ Ссылка ]
🔗Pragmatic Works Blog: [ Ссылка ]

Let's connect:

✔️Twitter: [ Ссылка ]
✔️Facebook: [ Ссылка ]
✔️Instagram: [ Ссылка ]
✔️LinkedIn: [ Ссылка ]
✔️Discord: [ Ссылка ]

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#pragmaticworks

00:00 - Introduction
01:06 - Overview of Fiscal Year Date Tables
01:22 - Starting the Fiscal Year Date Table in Power BI
01:47 - Using the Calendar Auto Function
02:17 - Setting the Fiscal Year Start Month
03:09 - Adding Columns to the Fiscal Year Date Table
03:32 - Creating Fiscal Month Number Column
05:56 - Creating Fiscal Quarter Number Column
07:50 - Adding the Fiscal Year Column
10:29 - Explanation of DAX Variables and Functions
11:22 - Completed Fiscal Year Column Review
11:44 - Conclusion and Next Steps

свернуть