Forum Discussion

Alpha1029's avatar
Alpha1029
New Member
7 years ago
Solved

Cumulative Total till today

      Hi    I want to get cumulative totals according to the dates till today and for all the future dates cumulative total should be shown as zero or blank. I went through some examples but those...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    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

  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Alpha1029It needs to be created as a measure, not a calculated column.  The measure can be added to a visual table as a column.

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Alpha1029It needs to be created as a measure, not a calculated column.  The measure can be added to a visual table as a column.

Pow21er's avatar
Pow21er
New Member
3 years ago

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.