Forum Discussion
Running Cumulative based on hours
I need your help on a DAX formula to calculate the third column 'CumulativeForTheDay' that's is required to be a running total. The required calculation will be for 24 hours starting at '01:...
Anonymous
Creata a new table and add as dimension the timestamp sorted in Ascending order.
Then create a measure using the following formula and add it to the table.
If you want to see the running total for a specific date, add a dare slicer and select the date you want
Cumulative =
CALCULATE (
SUM ( Table[FlowAtGivenInterval] ),
FILTER( ALL (Table ),
Table[TimeStamp] <= MAX( Table[TimeStamp] ))
)Hello themistoklis,
Thanks for taking the time to reply. The problem with your solution is that is doesn't break on new days. It keeps accumulating on consecutive days.