Forum Discussion

kelvin-lkhca's avatar
kelvin-lkhca
Helper I
3 years ago
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 - Copy, otherwise, it will take from column Period.

 

I have tried the custom column but the logic I know of doesn't work. Hope that I can find the solution here.

 

 

 

2 Replies