Forum Discussion
Cumulative Total till today
Try this:
Running Total = var __MaxDT = max(Table[Date]) var __Rtotal = CALCULATE(SUM(Table[Value]), Filter(All(Table), Table[Date] <= __MaxDT) ) RETURN IF (__MaxDT > TODAY(), 0, __Rtotal)Hope this helps
David
Alpha1029It needs to be created as a measure, not a calculated column. The measure can be added to a visual table as a column.
Community ChampionTry this:
Running Total =
var __MaxDT = max(Table[Date])
var __Rtotal =
CALCULATE(SUM(Table[Value]),
Filter(All(Table), Table[Date] <= __MaxDT)
)
RETURN
IF (__MaxDT > TODAY(), 0, __Rtotal)Hope this helps
David
Hi David
I tried the way you suggested and I got zeros in the Running Total Column.
- dedelman_clng
Alpha1029It needs to be created as a measure, not a calculated column. The measure can be added to a visual table as a column.
Greg_Deckler I tried to create it as measure and still it gives me all zeros . Any suggestions...
Greg_DecklerIt works if I create it as a measure. I was checking it in the wrong place. Sorry for coming to a conclusion so quickly.
Thanks a lot for the help. It works fine now.
Hi. I have a question. I tried this and it worked but ı have a question. I want to see total of 3th,4th and 5th row in 3th row. Other fields okey but i didnt solve this problem.
Details: I have a checklist and i want to see cumulative toplam till today of status column. I made it but sometimes we are log in data for future and i cant see on the table. So ı want to total for today.
