Forum Discussion
YTD Cumulative for weekly figures
I am trying to create measure for the cumulative columes. Below is the DAX code I wrote. As you can see in the last colume of the visual, it is still showing by week numbers not cumulative by week...
Pmorg73
Post Patron
Post Patron[my first attempt to answer a query for someone else!!] 🙂
I assume you already have a calendar set up? But replace the calendar[date] in my version for your date column and it should work for you.
this is a good cumulative measure that I use a lot if you do:
Tonnes 2019 cumulative = CALCULATE('scale data 2019 2020'[tonnes],
FILTER(ALLSELECTED(calendar'[Date] ) ,
'calendar'[Date] <= MAX('00_calendar'[Date])))
Thanks a lot for your reply. Jen