ASK MAVEN: Fiscal Calendars with Power BI + DAX
Learn from Maven Analytics instructors as we explore some of the most interesting analytics & business intelligence questions our students have asked!
In this video, Lead Power BI Instructor Aaron Parry dives into fiscal calendars in Power BI, and how to write DAX measures for custom time intelligence calculations.
★★★★★ Looking for our best-selling Excel, Power BI, Tableau, and SQL courses?
Sign up for a 100% FREE account at Maven Analytics (no cc required), and start learning today:
👉 https://www.mavenanalytics.io/
Follow Maven Analytics on LinkedIn for monthly challenges, free data sets, blog posts, and more:
👉 / 35519409
Video Timestamps:
0:15 - Introducing the question
0:50 - The Maven Roasters data model
1:14 - Intro to 4-4-5 and 4-5-4 calendars
1:55 - Fiscal calendar table in Power BI
4:00 - DAX measure for MTD sales
5:03 - DAX measure for Previous Month sales
#powerbi #dax
