cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
christianyepez2 Regular Visitor
Regular Visitor

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 rank.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Chihiro Established Member
Established Member

Re: Ranks with difernt dates

Try RANKX().

 

Something like below as calculated column.

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

 

0.JPG

 

 

1 REPLY 1
Chihiro Established Member
Established Member

Re: Ranks with difernt dates

Try RANKX().

 

Something like below as calculated column.

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

 

0.JPG