I have an excel formula in column D below using this formula.

=IF(COUNTIFS($B:$B,$B2,$C:$C,"Y")>0,"Y","N")

How can I do the same thing in power query? I understand that using group by does the job on countifs but how can I bring it all together as a new column in Power query?