Forum Discussion
Running total based on time
I have the following table that I want to use as a running total for an area chart + a matrix visual: Additionally, for my table the day doesnt end at 00:00, but after 03:00 am (see last li...
Hi Anonymous ,
Are the date and item number column from the same table?
Do you mean creating the slicer like this?
If yes, you can try this measure.
RT = VAR thistime = MIN ( 'Table'[Time] ) RETURN CALCULATE ( SUM ( 'Table'[value] ), FILTER( ALLSELECTED ( 'Table' ), 'Table'[Time] <= thistime ))If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
I tried your formula and it seems to be exactly what I was looking for, however, it seems to reset on negatives/positives: