Rankx on more than 1 column

[MasterSonic]

Hi guys,

1 table with multiple columns, 2nd table too. Tables are linked with column Code

Columns of our interests are 

Table1[Code]

Table2[Group]

Table2[SoldDate]

I would like to rank it by SoldDate and Group

Can anyone advise please 

[ValtteriN]

Hi,

As you suspected RANKX would be the function to use in these kind of scenarios. I recommend checking this article by SQLBI: https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/

You should be able to consctruct the measure you are looking for with the methods described there.