Condition a column

[Syndicate_Admin]

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
10	3

It should end like this.

Value 1	Value 2
1	5
8	8
2	2
10	3

Thank you.

[m_dekorte]

Or simply apply a Replace Values step to the column "Value 2".

Table.ReplaceValue(PrevStepName,null,each [Value 1],Replacer.ReplaceValue,{"Value 2"})

I hope this is helpful

[Edward93]

[Edward93]

I don't recognize this logic:

PrevStepName

[m_dekorte]

That PrevStepName reference needs to be replaced with the previous step name from the Applied Steps. If you are unfamiliar or unable to pass it succesfully - try this approach:

1. In the Applied Steps pane, select the step where you want to insert this code (typically, that's the last step you see there)

2. Press the fx in front of the formula bar  - this will insert a manual step for you - AND return the previous step name.

3. Copy this step identifier from the formula bar and insert it in the place of the PrevStepName within the provided code.

4. Now you can copy and paste this updated expression back into the formula bar

I hope this is helpful

[Vijay_A_Verma]

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]})))