Forum Discussion
Output Unique Rank for Same value in a table
| ID | Value | Area | Concatanation | Desired Output |
| A1 | 24 | AAA | A124 | 1 |
| A1 | 24 | BBB | A124 | 2 |
| A2 | 13 | AAA | A213 | 1 |
| A2 | 13 | BBB | A213 | 2 |
Hi,
I've got a table laid out similar to the above. I would like to create a column that gives these values a rank based on a concatanation of the ID and Value.
For example. A124 would appear twice. but i would like the first instance to display as 1, the second as 2 and so on.
Does anyone know how I could acheive this with a DAX function?
I've managed tis in excel previously, but that was simple using the specific dynamic ranges based on cell address.
HI jpmuk,
I think this should more suitable to achieve in the query editor, you can add an index column based on column groups:
Create Row Number for Each Group in Power BI using Power Query - RADACAD
Regards,
Xiaoxin Sheng
2 Replies
HI jpmuk,
I think this should more suitable to achieve in the query editor, you can add an index column based on column groups:
Create Row Number for Each Group in Power BI using Power Query - RADACAD
Regards,
Xiaoxin Sheng
