COUNTIF in Power Query

[Deeno_Sebastian]

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)

[#2]

@Deeno_Sebastian 

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

[#3]

@Deeno_Sebastian 

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