Help with If function and matching between two columns

[mathias1998]

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

[KT_Bsmart2gethe]

Hi @mathias1998,

if [Column1]=[Column2] then -1 else 0

Regards

KT 

[mathias1998]

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

[KT_Bsmart2gethe]

Hi  @mathias1998,

COUNTAX(FILTER(Table,[Column1]=DATE(2022,9,1)),[Column2])

Regards

KT