Forum Discussion

Niki's avatar
Niki
Helper III
7 years ago
Solved

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 ...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    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.