Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Post Patron
8 years ago
Solved

Normal cumulative sum

Hello all,   I want to show normal cumulative within line chart.   My Axis has to be 3 years hence I use this :   MonthYear Retention breakdown = FORMAT(Terminations[Date of Renewals],"mmm")&"-...
Need Help
  • Daniil's avatar
    Daniil
    8 years ago

    Of course... :-)

     

    You just need to also include the column you are sorting by in ALL. Like so:

    Retention Cumulative =
CALCULATE (
    [Retention],
    FILTER (
        ALL (
            Terminations[Date of Renewals],
            Terminations[MonthYear Retention breakdown],
            Terminations[SORT COLUMN OF MonthYear Retention breakdown]
        ),
        Terminations[Date of Renewals] <= MAX ( Terminations[Date of Renewals] )
    )
)

    Does this make sense?

Daniil's avatar
Daniil
Kudo Kingpin
8 years ago

Of course... :-)

 

You just need to also include the column you are sorting by in ALL. Like so:

Retention Cumulative =
CALCULATE (
    [Retention],
    FILTER (
        ALL (
            Terminations[Date of Renewals],
            Terminations[MonthYear Retention breakdown],
            Terminations[SORT COLUMN OF MonthYear Retention breakdown]
        ),
        Terminations[Date of Renewals] <= MAX ( Terminations[Date of Renewals] )
    )
)

Does this make sense?

AndrejZitnay's avatar
AndrejZitnay
Post Patron
8 years ago

Hello Daniil

 

It makes now and now it works great.

 

Many thanks for your help.

 

Kind regards.

 

Andrej