Forum Discussion
Solved
Replace Error
Hi guys, Is it possible to replace errors in a column in power query with the value from another column in the same table? So for example in my case I want every column's error valu...
Thank you very much for your replies guys,
What I did was the following,
Replace error with null,
Then I replaced null with a numerical value that was higher than any other possible value in the column.
In my case the values were from 1-10 so the value I added was 110
Then I went to the code and replaced 110 with: each [General rating]
Thanks for your time,
Have a lovely new year
