Forum Discussion
jpmuk
4 years agoFrequent Visitor
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 ...
- Anonymous3 years ago
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
amitchandak
Super User
4 years agojpmuk , refer if Rank Tie breaker can help
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/