Forum Discussion
Niki
Helper III
Helper IIImatrix column header sort DESC!!
Hi all, Going crazy! So hope any one can help. I have a column with dates which are the matrix column series. I want the most recent date to show up first, but it seems microsoft is recognizing ...
What is your data source? If it is SQL, then you could add a Rank column while importing the data to tabular model:
Rank() over(order by settlementdate DESC) AS DateSort
Afterwards, you could sort Date column by this DateSort column.
AkhilAshok
Solution Sage
Solution SageWhat is your data source? If it is SQL, then you could add a Rank column while importing the data to tabular model:
Rank() over(order by settlementdate DESC) AS DateSort
Afterwards, you could sort Date column by this DateSort column.
NikiThanks! it works :)