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

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.