Forum Discussion
Solved
Merge two columns into one column based on two condition
Hi there, I am hoping someone can help me with a conditional column that I have created in Power Query. I have the following table (called This Month) and I am trying to combine the first two column...
Hi ClemFandango,
When dealing with null (the absense of a value) you can use coalesce (??), to illustrate:
Table.AddColumn(#"Replaced Value", "Custom", each [#"Table1 (Active a).AC Cust Num"] ?? [#"Table1 (Inactive b).AC Cust Num"])
The error you reported is most likely due to the double set of square brackets within your syntax.
Hi ClemFandango,
When dealing with null (the absense of a value) you can use coalesce (??), to illustrate:
Table.AddColumn(#"Replaced Value", "Custom", each [#"Table1 (Active a).AC Cust Num"] ?? [#"Table1 (Inactive b).AC Cust Num"])
The error you reported is most likely due to the double set of square brackets within your syntax.
Amazing - m_dekorte you are my hero!