Count rows in Power Query

[PeterWu]

Hi 

I want to add a new column in Power Query and count the number of PN in the new column.

I made a result in Excel table. could you teach me how to do it in power Query?

Thanks 

[PeterWu]

Hi @Vera_33 

Sorry, One more question. If I want to get a percentage of the new column, for example it should be 33% in both AA1 and BB1. how should I do on the coding

[Vera_33]

Hi @PeterWu 

You mean you don't need count = 3, but percent instead? Buffer the list as well

[PeterWu]

Hi

Which way is more efficiency if I have huge data set?

[Vera_33]

Hi @PeterWu 

List, buffer the list first

[Vera_33 · Accepted solution]

Hi @PeterWu 

There should be different ways to do it, List.Count or Groupby then join, file attached for your reference