Count the occurrence for each value

[Keith011]

Hi,
I want a Custom Column formula (not advanced editor) to calculate the occurences

I was thinking of Table.RowCount(....) but how do i achieve the below result?

Values	Occurrence
A	3
A	3
A	3
B	2
B	2
C	4
C	4
C	4
C	4

[jgeddes · Accepted solution]

The #"Changed Type" needs to be the previous step in your query.