Forum Discussion
Sort a Date Hierarchy in Chronological/Reverse Chronological Order in a Matrix
I have a Matrix that's essentially a Date Hierarchy & aggregated Financials. How do I make it such that this can be sorted both in Chronological order and Reverse Chronological Order? By default, Chr...
Hi,
I'm not sure this is possible by default now to sort by two columns at once. There is the following idea if you want to vote for it:
I think you could create an additional column like this one:
YQ = (Sheet1[Year] ^2) + RIGHT(Sheet1[Quarter],1)
The issue here is that you'd have to include this column in your visual and sort by this column. It produces the following results:
(descending)
(ascending)
Please let me know if this is helpful or if I've misunderstood your issue.
Thanks,
Ben
What if I need to do this by Month? where my Month column is the name of the month.
YM = ([Date to PO Complete].[Year]^2)+RIGHT([Date to PO Complete].[Month],1)
Your dax wants to change it to a number