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
Icon for Community Support rankCommunity Support
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.