Forum Discussion

brslagle's avatar
brslagle
New Member
2 years ago
Solved

Sort Matrix by descending timestamp

Hi all, I have a matrix table that has a list of timestamps as the columns (see below)... I want to be able to have the most recent timestamp show first (left most) and then progress (right) in a descending order (the timestamps also can repeat)... I have tried multiple different solutions with index columns and then selecting that to sort the timestamp column but I have not had any luck... Any help would be appreicated. 

 

 

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi brslagle 

     

    First, you can create an index column in Power Query, and then sort your date column by index column.




    This is the result you want:

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Index column is going in the right direction.  However, you need to reverse its order.  Say you have 10000 rows, then use 10001 -[Index]  as your "sort by"  column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi brslagle 

     

    First, you can create an index column in Power Query, and then sort your date column by index column.




    This is the result you want:

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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