Forum Discussion

kellyylx's avatar
kellyylx
Helper I
2 years ago
Solved

Grouping duplicates

Hi, I have a column called name with duplicates and I want to create the group column which assigns a number to records of the same duplicate group. 

 

namegroup
A1
A1
B2
B2
C3
C3
C3
E4
F5
G6
G6
H7
I8

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    kellyylx 

    is this what you want?

     

    Column = CALCULATE(DISTINCTCOUNT('Table'[name]),FILTER('Table','Table'[name]<=EARLIER('Table'[name])))
     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    kellyylx 

    is this what you want?

     

    Column = CALCULATE(DISTINCTCOUNT('Table'[name]),FILTER('Table','Table'[name]<=EARLIER('Table'[name])))