Help Microsoft Power BI

CorNokZ

Currently a stay at home dad
Joined
Jan 24, 2004
Messages
19,779
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

FH is my second home
Joined
Dec 22, 2003
Messages
9,817
Power query is about as fun as being stabbed in the face

Good luck!
 

CorNokZ

Currently a stay at home dad
Joined
Jan 24, 2004
Messages
19,779
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

FH is my second home
Joined
Dec 22, 2003
Messages
9,817
Well using normal excel is about as much fun as being stabbed in the face twice

So its better but still an awful experience
 

Users who are viewing this thread

Top Bottom