Creating an Index Column for a Descriptive Data Using “DAX” in Power BI

Question

I have a table Like this,

Table1

enter image description here

I want to create a column called as Row Number using DAX and not Query Editor (M).

So the Expected output is,

enter image description here

This can be done in M - Power Query Side.

But, I am looking for a solution using DAX- Calculated Column.

Additional source data

enter image description here

Alexis Olson Alexis Olson · Accepted Answer · 2021-01-17T23:23:34

The RANKX function should work fine for this purpose.

Row Number = RANKX ( Table1, Table1[ColA] )