Forum Discussion

elois33's avatar
elois33
Helper I
3 years ago
Solved

Sort by time

Hello,    How can I sort my martice table by hour, starting from the earlieast departure time for each "id bus"   Here is an example of my data in Excel. I already tried right click, sort by depar...
Need Help
  • elois33's avatar
    elois33
    3 years ago

    Hello all, 

     

    I found a solution for this and it seems to be the right one for now, so I am sharing it with you in case somebody has the same issue . 

     

    -To sort by time, I created a new column where I turned hour into second, I added it to my visual, I selected sort by second and then I hide it from my table. 

    -To sort my table by geographical order, I created a new column where I multiplied longitude x latidude, I added to my table and I sorted by the result of this new column.

     

    Thank you all for your time and help 

     

    Kind regards, 

    Elois

elois33's avatar
elois33
Helper I
3 years ago

Thank you v-xiaotang ! I used the the measure that you suggested and is says : "the second argument of the calculate function is needed" 😕 Any ideas what can I do? 

 

Thank you very much

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi elois33 

Thanks for your reply.

Please check if rankx() is used correctly? 

rank =
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[ID bus] = MIN ( 'Table'[ID bus] ) ),
    CALCULATE ( MIN ( 'Table'[departure] ) ),
    ,
    ASC
)

RANKX function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Tang

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