Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Ranks with difernt dates

Hello,    I have three diferent tables with a ranking clasification for a "$/kg" measure for 3 difernet products, I need your help to filter the ranks for each date and for each product, don´'t kno...
Need Help
Show and Tell
Tutorial Requests
  • Chihiro's avatar
    Chihiro
    8 years ago

    Try RANKX().

     

    Something like below as calculated column.

    =RANKX(FILTER(TableName,[Date]=EARLIER([Date])),[$/kg],,ASC)

     

     

     

Chihiro's avatar
Chihiro
Icon for Solution Sage rankSolution Sage
8 years ago

Try RANKX().

 

Something like below as calculated column.

=RANKX(FILTER(TableName,[Date]=EARLIER([Date])),[$/kg],,ASC)