Reversing Date Axis Matrix

[HenryJS]

Hi all,

Is it possible to sort date axis in a matrix from newest to oldest?

[v-eqin-msft · Accepted solution]

Hi @HenryJS ,

For my test ,  to avoid "circle", you could creata a new table using the following formula:

Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[Type],
    'Table'[Value],
    "index", RANKX ( ALL ( 'Table' ), 'Table'[Date],, DESC )
)

Then  select Date column ,sort by Index column, so that  dates in calculated table could be in descending order in Matrix 

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

@HenryJS  you will have to create a index colum in Power query editor for the sorting to work



sort the column based on Index number




The expected result are as below

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

[HenryJS]

@Anonymous the 'week ending' column I am trying to do the sort to is in a DAX table. Is it possible to do for a column like this?