Forum Discussion

nankerp's avatar
nankerp
Helper 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 )
    )

2 Replies

  • AkhilAshok's avatar
    AkhilAshok
    Solution 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 )
    )