Sort Matrix

[thebeginner1204]

Hello together

How can I implement sorting in descending (2) order by date in a matrix form date table (1)?

 Sorting in the table tools has no effect.

 

THX for help.

[v-weiyan1-msft · Accepted solution]

Hi @thebeginner1204 ,

Based on your description, you might consider adding an index column.
My Sample:

1.In the Power Query Editor，click on 'Index Column' on the Add column tab after sorting your table in descending order by Date column.

2.Click on the Date field in the Field pane and do the following:

Result is as below.

For further details，please find attachment.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@thebeginner1204  Maybe this will work:

- Create a Date1 column in your date table: Date1 = 'Date Table'[Date]
- Create a Sort column in your date table: Sort = RANKX ( ALL ( 'Date Table' ), 'Date Table'[Date],, DESC, Dense )
- Sort the Date1 column by the Sort column, then use the Date1 column in your matrix