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 know what is best, if crating a new table o crating measures? this 3 tables are summaries tables of other tables. 

 

Thank you so much 

 

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)

     

     

     

1 Reply

  • 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)