Forum Discussion

Warren10976's avatar
Warren10976
Regular Visitor
4 years ago
Solved

Copy values from one column to another

I have a column containg text and date in power query, how do I copy text values only to new column and date values only to another column. I need this information to be in seperate columns. Thank yo...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You should copy the formula as it is rather than writing.

    You put one comma after null and also ommitted try part. Copy and paste the below formula

    = try if Value.Is(DateTime.From([Opened]), type datetime) then null else [Opened] otherwise [Opened]
Warren10976's avatar
Warren10976
Regular Visitor
4 years ago

Thank you so much for the solution, 

  • The date part worked like a charm (
    Date.From(DateTime.From([Data])) otherwise null​
  • The text part is not working, See below 

  • Your assitance is much appreciated.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

You should copy the formula as it is rather than writing.

You put one comma after null and also ommitted try part. Copy and paste the below formula

= try if Value.Is(DateTime.From([Opened]), type datetime) then null else [Opened] otherwise [Opened]