Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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 Anonymous ,

     

    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
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You could create a rank column to sort category.

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