Forum Discussion
multi column sort
How can we sort a table using two or more columns? I want to sort by fiscal year order first and then by size of deal next (large to small).
Thats unfortunate. Isn't there a work around using DAX and adding a third column to sort.
Hi Anonymous
Have a look at this post for a formula for a Rank based on two columns.
You could use a measure like this for sorting possibly.
Owen