Dynamic Fiscal Year Date Table using DAX in Power BI

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 https://prag.works/AMELIA40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter: https://prag.works/yt-twitter
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
✔️Discord: https://prag.works/yt-discord

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#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

Тэги:

#Power_BI #fiscal_year_date_table #Power_BI_DAX #creating_date_tables #Power_BI_tutorial #DAX_functions #fiscal_calendar #business_intelligence #Power_BI_fiscal_year #Power_BI_date_table #Amelia_Roberts #Power_BI_tips #Power_BI_training #data_modeling #Power_BI_examples #fiscal_year_setup #custom_date_tables #Pragmatic_Works #Power_BI_certification #Cert_XP_promotion #Power_BI_learning #dynamic_fiscal_year_date_table #dynamic_date_table

Скачать видео