Forum Discussion
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.
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.
That's what I was looking for. Thanks so much.
chaichatp You're very welcome. Glad it worked. 🙂
