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
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.