Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago
Solved

Power Query M calculated column countif - minus - count blanks

Hi guys I am looking for a help with creating column based on this logic:   count rows where values is not "Day" minus count of blank values    Could you help me with that please.
  • amitchandak's avatar
    amitchandak
    4 years ago

    MasterSonic , Try a dax calculated column of measure

     

    countx(filter(Table, Table[value]<> "Day"), Table[value]) - countrow(filter(Table, isblank(Table[Value])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

MasterSonic , Try a dax calculated column of measure

 

countx(filter(Table, Table[value]<> "Day"), Table[value]) - countrow(filter(Table, isblank(Table[Value])))