Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Replace values in multiple columns with conditional

HI Community, hope you can help me. i want to do a replace value text in more than two columns based on a condition. if null = NO else YES   but the formula does not work can you help?? ...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

HI Anonymous ,

 

  1. In Power Query Editor, just select all the columns in which you want to replace Nulls (Ctrl+Click on Windows).
  2. Right Click
  3. Select Replace Values
  4. Enter the relevant the details in the window that appears and click Ok.

This will do the replacement in one step.

 

Thanks,

Pragati