Countif in power query

[aboly8000]

Hello
How do I execute the following code in Power Query?

[FONT=monospace]=IF(COUNTIF($B$2:B2,B2)=1,1,0)[/FONT]

 

[James006]

Hello,

See this link.

https://www.myexcelonline.com/blog/group-rows-get-counts-using-power-query/

Hope this will help

 

[aboly8000]

[h=2]I'm trying to do this in Power Query

1. Excel PivotTable Count Unique Items pre 2013[/h][FONT=&quot]Pre Excel 2013 you need to use a workaround, which is this:[/FONT]

1. 
   [*=1]Add a helper column to your raw data with a formula that counts a 1 for the first instance of the product, and a zero for any duplicates.

[FONT=&quot]

[/FONT]
[FONT=&quot]In cell E2 I entered this formula:[/FONT]
=IF(COUNTIF($B$2:B2,B2)=1,1,0)