COUNTIF in Power Query


Hi friends,

Is there way that I can get a similar "countif" function in power query.

I need to get the count value in each row.




Power query.jpg

2 Replies


That would be achieved through group by Employees and setting it to Count occurrences.


An alternative could be with List.Count and Table.SelectRows.