Forum Discussion
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...
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]
Thank You so much it worked