Forum Discussion
Power BI- Order Column with Repeative Values
I have 2 Columns, I am able to Sort Category Column by category ID but, Each Category has Position in it, and I also have PositionID against them and wants to sort Position by Category and PositionI...
You could create a custom column with the below formula to give you a unique sort/index column
= ([Category ID] * 100) + [Position ID]