Forum Discussion
Sorting by latest column values in Matrix
Hi there, I'm trying to sort a matrix by the latest column values (ascending/descending), these are Jun-2021 values in my case. Been trying to find a solution to this for quite awhile now but to ...
Anonymous,
Try this solution.
1. Create a calculated column equal to your existing [Month Year] column.
Month Year Desc Sort = DimDate[Month Year]
2. Create a calculated column for sorting. This requires column [Year Month Num], with values such as 202101.
Month Year Desc Sort Order = DimDate[Year Month Num] * -1
3. In the Data view, sort [Month Year Desc Sort] by [Month Year Desc Sort Order].
4. Use [Month Year Desc Sort] in a visual.