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])))

1 Reply

  • 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])))