Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    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.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi Anonymous ,

 

Do you have a date column? Or just a Time column?

We create a sample and it doesn’t reset on negatives/positives.

 

 

Could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

It will be helpful if you can show us the exact expected result based on the tables.

 

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

 

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.