How to work with Dates in Power BI - 5 Essential Concepts

By Chandoo

Community Score: 50% | 108 views | 3w

0 community ratings: null thumbs up, null thumbs down

DAX Date Intelligence functions simplified 💥$50 discount on my Power BI Course: https://chandoo.org/wp/power-bi-course/ (discount code: SAVE50) In this Power BI tutorial, I show you how to handle common business reporting requirements using the awesome chocolates data model. We walk through five essential date intelligence concepts for tracking performance, from basic month-on-month changes to complex same-period-last-year comparisons. By using these Time intelligence functions, you will gain a clearer picture of your shipment data and product trends. I also demonstrate how to implement moving averages using DAX formulas to smooth out volatility in your reports. Concepts covered in this video: 1) Calendar table and how to set it up 2) Basic trend analysis with your data 3) YTD, QTD, MTD - Year to date, Quarter to date, Month to date calculations with DAX 4) YTD with custom year end (ex: financial year ends in June ) 5) Month to Month Changes, Variance and % Calculations 6) Comparin

Tags: chandoo, chandoo.org, Excel, spreadsheets, Power BI Date Intelligence, DAX formulas, Power BI tutorial, Time intelligence functions, power bi tutorial for beginners, data analytics project, power bi time intelligence, power bi ytd, dax ytd custom year end, power bi moving average