Ranks with difernt dates

[Anonymous]

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 

[Chihiro · Accepted solution]

Try RANKX().

Something like below as calculated column.

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