Forum Discussion

aburling1989's avatar
aburling1989
Frequent Visitor
6 years ago
Solved

Sort column by multiple columns

Hi,   I was wondering if it was possible to sort a column based on two columns?   In the example below I'm trying to sort the Category by the Sort_Order column. The problem is that the sort order...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi aburling1989 ,

     

    You could create a rank column to sort category.

    Rank =
RANKX ( 'Table', 'Table'[Group] * 10 + 'Table'[Sort_Order],, ASC, DENSE )

     

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi aburling1989 ,

 

You could create a rank column to sort category.

Rank =
RANKX ( 'Table', 'Table'[Group] * 10 + 'Table'[Sort_Order],, ASC, DENSE )