Dax formula help needed

[Anonymous]

Hello, I was trying to make another coulmn that will check each coulmn from left to right to show what leg of each of my shipments are at. So like if its at port, at sea, on rail, or out for delivery. Can anyone help me out with that?

[Anonymous]

So I tried that last suggestion, but it didn't come out for what I was looking for. So for example I am tracking each leg of a container. It starts off at port, then sea, then rail, then out for delivery. SO those 4 columns show if a container has completed that part of the leg, I need to see what the current leg that container is in, so if it doesn't have any info in it then then that container is currently in the prior column with data.

[mahoneypat · Accepted solution]

Just reverse the order of the columns in the COALESCE() function that @Mariusz suggested.  That will return the value in each column in that order if it is not blank, so the order needs to be reversed to get your desired result.  With the current order, you got "At Port" for every row because it is not blank for all rows.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

That worked. Thank you so much. 

[Mariusz]

Hi @Anonymous 

Try this 

Column = 
COALESCE( 'Table'[Port], 'Table'[Sea], 'Table'[Rail], 'Table'[In Route to RDC/DC] )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Pragati11]

Hi @Anonymous ,

Your requirement is not very clear to me regarding the output you are looking for.

In your new calculated column do you need a concatenation of all the values from Column 1 to Column 3 ?

Kindly describe the required output.

Thanks,

Pragati