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

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

Hi elois33 

Thanks for reaching out to us.

if you want to sort table by departure, you can hover over here and click on the triangle icon

if you want to sort table by departure and ID, you can create the measure below,

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

 

 

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.

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.