Count number of instances aginst each entry

[LeeM]

Hi,

I'm a new user to Power BI and trying to replicate some functionality that I use in Excel.

Using an existing Excel table which has entries of A1:A10.

I use the following =Countif(A:A,A1) in cell B1, which I then copy down to the end of the data B10

Against each row (B1:B10) it would then show how many times the text in the referenced cell appears in the array.

I want to try and replicate this in power query.

I've searched and searhced but can't find anything that gives me the individual answers.

Many thanks Lee

[v-kkf-msft · Accepted solution]

Hi @LeeM ,

Please create the new column.

Column = COUNTROWS(FILTER('Table','Table'[Name] = EARLIER('Table'[Name])))

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[serpiva64]

Hi,

can you post an exemple in excel?

[LeeM]

Hi serpiva64, I've updated the original post with an example. Thanks Lee