Running total

[Anonymous]

Hello,

I need assistance with a formula for running total. I am using the formula below, but as you can see from the screenshot, the running total is not being calculated. What am I doing wrong?

RT_BUD_CL = TOTALYTD ( SUM('Summary Query'[BUD CL]), 'Summary Query'[DATE].[Date] )

'Summary Query'[BUD CL] is the value column

'Summary Query'[DATE] is the date column

[amitchandak · Accepted solution]

@Seth_OttoBros, What an annual total and measure

Total measurement running with date table

Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-maxx(date,date[date])))
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-max('Summary Query'[DATE])))

Como una nueva columna
Cumm á CALCULATE(SUM('Summary Query'[BUD CL]),filter('Summary Query','Summary Query'[DATE] <-earlier('Summary Query'[DATE] )))

To get the best out of the time intelligence function. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of your events. See :radacad sqlbi My Video Series Appreciate your congratulations.

[Anonymous]

Thanks Amit, works perfectly.