Cumulative over all dates up to now?

[Anonymous]

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!

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@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