Forum Discussion
Cumulative over all dates up to now?
Dear all,
I was wondering whether there was a way to make a cumulative similar to TOTALYTD, but not for a specific year but over all years in total? Like a TOTALTD function.
This calculates the total year to date, but I would like to calculate the total cumulative to date.
TOTALYTD(SUM('original data'[Revenue]);'original data'[Date];ALL('original data'))
Thanks!
Hi Anonymous ,
If you want to calculate the total of all years to current date , I'd suggest you use
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])))Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
Anonymous Seems like CALCULATE(SUM('original data'[Revenue]); ALL('original data'))
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008 Hi Anonymous ,
If you want to calculate the total of all years to current date , I'd suggest you use
Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])))Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
