Forum Discussion
Sorting a Matrix
I have been trying to sort my report MATRIX from date ascending (Text field) to date descending for many hours. I have tried the sort column by, but the data is so variable and the way weeks have wor...
Apologies, I am lost, are these Measures, Calculated Fields, Other. If I start using DAX it rates them all as 1 due to max, min or average
It was a rough idea to use Rankx, the solution of sorting could be different for cases. It is difficult for us to understand your model just by a few sentences. Can you share a sample pibx which is a straight forward way for us to know your current problem.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My report is a matrix with column headers
WE 2020-01-05 WE 2020-01-12 etc ... to Current Weeks
I simply want to resort it into reverse order