COUNTIF in Power Query

Visitor

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.

 

 =COUNTIF($D$2:$D$13,D2)

 

Power query.jpg

2 Replies

@Deeno_Sebastian 

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

@Deeno_Sebastian 

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

countif.JPG