Forum Discussion

cjl2144's avatar
cjl2144
New Member
7 years ago

Power Query - count columns with specific values

Is there a way to implement a "COUNTIF" Excel function in Power Query for a custom column? Preferably without having to write formulas to check the value of each column individually?   For example,...
Need Help
hnguy71's avatar
hnguy71
Super User
7 years ago

My suggestion is to begin by using UNPIVOT OTHER COLUMNS, then use GROUPBY, then do a COUNT for your specific value

  • cjl2144's avatar
    cjl2144
    New Member
    7 years ago

    Thanks for the suggestion. Where can you implement a COUNT for a specific value? All of the options I am able to find only do a count of the number of rows. 

     

    • Mm3ndoza's avatar
      Mm3ndoza
      Frequent Visitor
      7 years ago

      Select the Nodes columns >> Unpivot Columns >> Filter Values = 6 >> Group by Date and Node and count the rows.

    • hnguy71's avatar
      hnguy71
      Super User
      7 years ago

      It should already count for you.

       

      Here's my example: