Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running total

Hello all,   I've this running total measure:   Running Total Ferien Rest = CALCULATE( SUM(DIA_SAP_ABSENZEN[Ferien Rest]), FILTER( ALLSELECTED(DIA_SAP_ABSENZEN), DIA_SAP_ABSENZEN[Datum] <= ...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Anonymous 

    I see that you're using the Date table fields for slicing. That's much better. Try this:

    Measure V4 = 
VAR max_ =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE ( SUM ( Table1[Ferien Rest] ), 'Date'[Date] <= max_, ALL ( 'Date' ) )

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AlB 

 

V4 did the trick. Thanks very much!

 

I've another complicated question. I'll run it by you on a private message before posting it in the open.