Forum Discussion
Niki
7 years agoHelper III
matrix 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 ...
- 7 years ago
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
7 years agoSolution Sage
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.
Niki
7 years agoHelper III
Thanks! it works :)