Forum Discussion
Helper IHow to create an Index column with random repeated column data.
Hi, WKN
According to your description, using DAX in desktop won't accomplish what you need if you only have two columns of data displayed without a unique identifier column. If necessary, you can add the unique identifier column and then use Rank, RANKX, ROWNUMBER functions.You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, WKN
According to your description, using DAX in desktop won't accomplish what you need if you only have two columns of data displayed without a unique identifier column. If necessary, you can add the unique identifier column and then use Rank, RANKX, ROWNUMBER functions.
You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Helper IHi,
Continued with further online search and found below article,
Count duplicate values and number them as 1,2,3.
Basically created another column to count the duplicates of the repeated Test hours. This enable an identifier per row for repeated Test hours. Not perfect though but good enough for now. Have yet to try a combination of Rank, RANKX, ROWNUMBER functions. Ok will consider submitting an idea for creating an index column based on only one data column with repeated row values.
Thanks to all who responded to this query.