Forum Discussion

IvanG92's avatar
IvanG92
Frequent Visitor
3 years ago
Solved

Moving RANK in a calculated column

Hi everyone,   I have a table with 2 columns: DATE and VALUE I need a calculated column with the value of the column VALUE ranked against the other values of the column VALUE that are released in ...
Need Help
  • IvanG92's avatar
    IvanG92
    3 years ago

    I think I found the solution:

     

    SP D_Yield (Abs) NORM. = rankx(CALCULATETABLE('SP D_Yield',DATESINPERIOD('SP D_Yield'[DATE],LASTDATE('SP D_Yield'[DATE]),-2,YEAR)),'SP D_Yield'[SP D_Yield (Abs)])
     
    I still don't know what it works with CALCULATETABLE and not with FILTER...
Shaurya's avatar
Shaurya
Memorable Member
3 years ago

Hi IvanG92,

 

You can use:

 

Rank = RANKX(FILTER(ALL('Session'), DATESINPERIOD('Session'[FullDate], MAX('Session'[FullDate]),-20,YEAR)),'Session'[Value],,ASC)

 

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

  • IvanG92's avatar
    IvanG92
    Frequent Visitor
    3 years ago

    It throws an error: "A table of multiple values was supplied where a single value was expected"