Forum Discussion
Solved
YTD Total
Hi All I need to get a year to date total not in an ordinary way: YTD Profit = var _numMonths = SELECTEDVALUE('Date'[Date].[MonthNo]) RETURN CALCULATE([Profit After Tax] ...
Lancelot , You can have measure like
YTD Profit = CALCULATE([Profit After Tax],DATESYTD('Date'[Date],"12/31"))
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Lancelot , You can have measure like
YTD Profit = CALCULATE([Profit After Tax],DATESYTD('Date'[Date],"12/31"))
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s