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]
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!