how to create a column getting the unique count of another column

[gheecalipes25]

Hi,

I am trying to create a column that would distinguish if the values of Column A has 1 or more occurences. like for example i have a column for Requestnumber&Region, and i would like to create a column that would determine if a specific rowdata has multiple instances. I would want to achieve the value below:

Column A	Generated Column
29845Americas	1
29845Americas	0
29845EMEA	1
29845EMEA	0
29845LA	1
29845LA	0

[gheecalipes25]

Thank you. it worked perfectly. 🙂

[jppv20 · Accepted solution]

Hi @gheecalipes25 ,

I'm not sure if I completely understand you question but you could try this:

Go to the Power Query Editor and add an Index Column:

Then create this column:

Generated Column =

var Count_A = CALCULATE(COUNT('Table'[Column A]),ALLEXCEPT('Table','Table'[Column A]),'Table'[Index]>EARLIER('Table'[Index]))

Return

IF(Count_A=BLANK(),0,Count_A)

Result:

If I answered your question, please mark it as a solution to help other members find it more quickly.