Forum Discussion
Solved
Set a Custom Column to retrieve from the Correct column
Hi All Gurus, Below are the two columns in my power query table. I wish to create a new column with the logic that if Col Period - Copy is not error, then it will take the value from Period - Cop...
Hi kelvin-lkhca ,
How about this:
The Power Query M syntax for the custom column is:
try [#"Period - Copy"] otherwise [Period]
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi kelvin-lkhca ,
How about this:
The Power Query M syntax for the custom column is:
try [#"Period - Copy"] otherwise [Period]
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
It works perfectly. I am so impressed by this formula which I had never come accross before.
Thank a lot!