Forum Discussion

nankerp's avatar
nankerp
Icon for Helper III rankHelper III
7 years ago
Solved

Running Total - Find the highest year

How do I find the year where the highest value is on a column with running total?  
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    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 )
    )
AkhilAshok's avatar
AkhilAshok
Icon for Solution Sage rankSolution Sage
7 years ago

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's avatar
    nankerp
    Icon for Helper III rankHelper III
    7 years ago

    Thank you very much. It worked.