Running Total - Find the highest year

[nankerp]

How do I find the year where the highest value is on a column with running total?

[AkhilAshok · Accepted solution]

Maybe something like this:

Total Resultat = 
SUM('Table'[Resultat])

RunningSum = 
CALCULATE (
    [Total Resultat],
    FILTER ( ALL ( 'Table'[Year] ), 'Table'[Year] <= MAX ( 'Table'[Year] ) )
)

Rank = 
RANKX ( ALL ( 'Table'[Year] ), [RunningSum],, DESC )

Max Running Year =
CALCULATE (
    MAX ( 'Table'[Year] ),
    FILTER ( ALL ( 'Table'[Year] ), [Rank] = 1 )
)

[nankerp]

Thank you very much. It worked.