Forum Discussion
Condition a column
Hello I would like to generate a condition in which if the "Value 2" column detects that it has "null" then it takes the data from column 1. Value 1 Value 2 1 5 8 null 2 null ...
Insert this step in Power Query where #"Changed Type" should be replaced with your previous step
Table.FromRecords(List.Transform(Table.ToRecords(#"Changed Type"), (x)=> Record.TransformFields(x, {"Value 2", each if x[Value 2]=null then x[Value 1] else x[Value 2]})))