Filter text with date and take information

[Anonymous]

Hi, I have a shipment with port information. We can see it started from CHINA - JAPAN - USA - CAN - BRITAIN based on ETD.

I would like to write dax to know the first port, second port, third, fourth and fifth port. And may use same logic for 1000+ order

Is the logic like,

Port 1 = calculate(??, ETD = lowest)

Port 2 = calculate(??, ETD = second lowest)...

Please help me with this, thanks!

[VahidDM · Accepted solution]

Hi @Anonymous 

Please download the attached file.

Output:

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[tamerj1 · Accepted solution]

Hi @Anonymous 
You can create a calculated column tht raks the orders then place it in a matrix visual. The only thing which I have doupt about is to make sure the date is actually a date type column not a text type column.

Prot Order = 
"Order "
    & RANKX ( 
        CALCULATETABLE ( 
            'Table', 
            ALLEXCEPT ( 'Table', 'Table'[Order Number] ) 
        ),
        'Table'[ETD]
    ) 

Port = SELECTEDVALUE ( 'Table'[Dep] )

[Anonymous]

Thanks! It works!!!

[VahidDM · Accepted solution]

Hi @Anonymous 

Please download the attached file.

Output:

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Anonymous]

Thank you so much! It works!