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