Secret of Time Intelligence Functions in Power BI
Time Intelligence functions in DAX are helpful in time analysis and creating calculations for year to date, quarter to date for calendar or fiscal categories. In this lesson you will learn how to use functions such as TotalYTD and TotalQTD combined with a date dimension to create measures in DAX and Power BI. You will also learn the difference between Power Pivot which allows you to set a date table, and Power BI which you have to add the ALL() filter in all time intelligence measures.