Calculate Totals for MTD, QTD and YTD in DAX

preview_player
Показать описание
Learn how to quickly use the CALCULATE function to get total from year to date, month to date and quarter to date in Power BI using a Calendar table and time intelligence functions in DAX.
Рекомендации по теме
Комментарии
Автор

Hi Sir, is it possible to give year end date dynamically in TotalYTD DAX instead of fixed like(4/30), so can u pls help me with this if there is a way

venkateshthammisetty
Автор

why did we add a calender? can'nt we use date already in the table?

SunilKumar-gsmn