Forum Discussion
Solved
IF statement in custom column
hello, i am trying to add a custom column where if value in column A is greater than 0 then column A value should appear, if not value from column B should appear, though if both column have nul...
rohitjmd Try this as a "Custom Column" in Power Query Editor
=if [A]=null or [A]<=0 then [B] else [A]
rohitjmd Try this as a "Custom Column" in Power Query Editor
=if [A]=null or [A]<=0 then [B] else [A]