Help Microsoft Power BI

[CorNokZ]

This is truly a wonderful product, but I've come across a thing which I cannot resolve. It seems rather simple, but I just can't get my head around it.

Basically I've got millions of urls in a column and I need to count how many times each on appears in said column. In normal Excel this is quite easy e.g:

Jim
Bo
Jim
Lars
Lars
Bo
Bo
Bo
Karsten
Lars

In order to count how many times each name occours I use the following formular: =countif($A$1:$A$10;A1) and I get the result

Jim 2
Bo 4
Jim 2
Lars 3
Lars 3
Bo 4
Bo 4
Bo 4
Karsten 1
Lars 3

I cannot figure out how to do the same in Power BI or Power Query as it is also called. Anyone got an idea how to do the same?

 

[Ormorof]

Power query is about as fun as being stabbed in the face

Good luck!

 

[CorNokZ]

Power query is about as fun as being stabbed in the face

Good luck!

You honestly think that? It is undoubtedly the biggest improvement since the first launch of Excel. Brilliant tool

 

[Ormorof]

Well using normal excel is about as much fun as being stabbed in the face twice

So its better but still an awful experience