How To Calculate Year To Date Sales For Non-Standard Calendar Tables Using DAX [2023 Update] скачать в хорошем качестве

How To Calculate Year To Date Sales For Non-Standard Calendar Tables Using DAX [2023 Update]

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