Index Column based on 2 columns while 1 column include some duplicated values

[chaichatp]

I already tried RANKX but didnt find out the right way.

[AllisonKennedy · Accepted solution]

@chaichatp  If you're just looking for an index column, you can also create in Power Query. This blog has more than you need, but the first bit is on simple Index: https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

What is your data source? The sort in Power Query sometimes requires a Table.Buffer step before or within the index, but after the sort.

[chaichatp]

That's what I was looking for. Thanks so much.

[AllisonKennedy]

@chaichatp  You're very welcome. Glad it worked. 🙂 

[amitchandak]

@chaichatp , You can use RankX with breaking ties. Mentioned in

https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...

[chaichatp]

Thank you. Let me try.