Forum Discussion

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

matrix: sort columns in descending order

matrix table: sort columns in descending order  ‎01-22-2017 12:05 PM - edited ‎01-22-2017 12:06 PM I too have this issue. It is common that when using Dates as Columns to have the most current o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I admit that there should be a possibility to sort them by the visual, but there is a workarround if you are only talking about some field.

I'm working with Azure SSAS so what did I do. Create a field in the data dimension that is 0-YYYYMMDD AS iYMD_Desc, Duplicated the Date Field as TheDate_Desc and Made the TheDate_Desc sorted by iYMD_Desc.

Works in Matrix