Forum Discussion

Pioneer's avatar
Pioneer
Regular Visitor
3 years ago
Solved

How to combine two columns dates into one column

Hi, How to combine two dates columns of a table  into one  new column .please check below sample data for reference.     expecting output:   Sample excelreport: In_Date         ...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Pioneer 

     

    This can only be done in Power Query.

    Copy two more tables, delete one of the columns from each table, change the column names to [In and Out date] and use Append.

    Select Remove duplicates.

    Join the initial table and the Append table to the right.

    Result:

    Click in the top right corner to expand.

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

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

Pioneer's avatar
Pioneer
Regular Visitor
3 years ago

 Anonymous 

We need to get all the dates, including blank values if existed from both the columns in  one new column and need to maintain unique data.

 

Thanks 

pioneer

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I think the best is do it in Power Query. You can duplicate the table and then append, and you will have something like this:

And you just should to combine both columns and remove duplicates.

  • Pioneer's avatar
    Pioneer
    Regular Visitor
    3 years ago

    Hi Anonymous 

     

    I have tried this method not working as expected,looking for any DAX column