Consolidate multiple columns into one column

[sunah132]

Hello, I'm currently working in import data and trying to know how I can consolidate columns into one.

There're some columns with truck delivery date, shipping delivery date, packing delivery date, and delivery date. They all have date values so I wanted to combine them into one delivery date column.

Could you please see how this should work?

Thank you.

[parry2k · Accepted solution]

@sunah132 try this to add a new column:

Delivery Date = 
COALESCE ( 
Table[Delivery Date], 
Table[Shipping Delivery Date],
Table[Packing Delivery Date], 
Table[Truck Delivery Date]
)

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@sunah132 what is the logic to combine? Not really clear what you want. You have to provide bit more context what you are trying to achieve. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[sunah132]

Hello,

This might be more explained of how this consolidation should be. My data has 4 delivery dates columns that should be combined into one column.

Thank you.