Forum Discussion
Replace Null with specific value for specific groups
Hi experts!
I have a column with some null values.
I have 2 additonal columns that display the group:
Group 1
Group 2
Value
A
A1
5
A
AG
null
A
A3
6
...
Insert this statement.
Replace source with your previous step. You didn't specify which word should replace null. I assumed joshua will replace null. Please replace joshua with right word
= Table.ReplaceValue(Source,each [Value],each if [Group 1]="A" and Text.EndsWith([Group 2],"G") and [Value]=null then "Joshua" else [Value],Replacer.ReplaceValue,{"Value"})