Forum Discussion

mathias1998's avatar
mathias1998
Frequent Visitor
3 years ago

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 Column...
Need Help
Show and Tell
mathias1998's avatar
mathias1998
Frequent Visitor
3 years ago

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's avatar
KT_Bsmart2gethe
Impactful Individual
3 years ago

Hi  mathias1998,

 

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

 

Regards

KT