Using DAX for time intelligence calculations in Power BI provides several advantages, such as the ability to perform complex calculations, create custom date ranges, and dynamically adjust calculations based on user selections.
However, when using custom calendars in Power BI, it is important to ensure that the calendar is set up correctly and that all time intelligence calculations are based on the correct date column. Additionally, it is essential to consider any differences in the length of periods, such as weeks or months, as this can impact the accuracy of time intelligence calculations.
In this tutorial, Sam is going to showcase how to calculate for Year to Date Sales when using non-standard custom calendar tables. Without the ability to use time intelligence function, we need to find another way of using CALCULATE and FILTER.
*****Video Details*****
00:00 Introduction
01:08 Custom Calendars
03:12 Calculating YTD Sales For Standard Calendars
04:11 Calculating YTD Sales For Custom Calendars
09:00 Conclusion
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial