Forum Discussion
Help with If function and matching between two columns
Hi,
I have two existing columns (Column1 and Column2), and I would like to create a new custom column in Power Query which returns:
-1 if Column1 and Column2 have the same values
0 if Column1 and Column2 do not match
Total count of non-blank rows from Column2 (essentially if the COUNTA founction in DAX) if Column1 contains 01.09.2022.
It would look something like this:
| Column1 | Column2 | Custom column |
| 31.08.2022 | null | 0 |
| 01.09.2022 | null | 2 |
| 02.09.2022 | 02.09.2022 | -1 |
| 03.09.2022 | null | 0 |
| 04.09.2022 | 04.09.2022 | -1 |
3 Replies
Thank you. But what about the following. How can that be done?
Return the Total count of non-blank rows from Column2 (essentially if the COUNTA founction in DAX) if Column1 contains 01.09.2022
