Forum Discussion
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 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 |
rohitjmd Try this as a "Custom Column" in Power Query Editor
=if [A]=null or [A]<=0 then [B] else [A]
2 Replies
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!
