IF statement in custom column

[rohitjmd]

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 null then null should appear in custom column. i tried to do this with custom and conditional column method but error appers in some rows in both method. please suggest.

A	B
null	null
null	null
null	null
0	null
null	null
0	null
null	0
null	5.94
7.75	null
7.75	null
3.93	null
4.12	null
4.12	null
3.98	null
4.2	null
8.5	null
null	null
null	null
4.2	null

[cooksteve09]

What if the column headers change each day? my problem is very similar, i have a date column which then i pivot so the dates become the column headers and i am after a custom column that looks at the previous day and returns those values if greater then the day before else show 0....any help would be greatly appreciate!

[PattemManohar · Accepted solution]

@rohitjmd  Try this as a "Custom Column" in Power Query Editor

=if [A]=null or [A]<=0 then [B] else [A]