Forum Discussion
Same client ID with different name variations
I am trying to segment data from clients but I have one problem: There are different name variations (or typing errors) for the same client ID.
| ID | First Name | Last Name | |
| 0918745654 | Wilhelm | Schwarz | |
| 0918745654 | Wilhelm | A. Schwarz | |
| 0918745654 | Wilhelm | Schwartz | (Typing error) |
| 0918745654 | Wilhem | Schwarz | (Typing error) |
My question is how do I create a measure that can group this names into a single one based on the unique ID.
Thank you all!
William
Anonymous you can create measure to get first and last name, and write another measure for Last Name
My First Name = CALCULATE ( MAX ( Table[FirstName] ), ALLEXCEPT ( Table, Table[Id] ) )
2 Replies
Anonymous ,
Try This:First Names = CALCULATE(CONCATENATEX(myTable,myTable[First Name]," ,"),ALLEXCEPT(myTable,myTable[ID]))Last Names = CALCULATE(CONCATENATEX(myTable,myTable[Last Name]," ,"),ALLEXCEPT(myTable,myTable[ID]))
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielAnonymous you can create measure to get first and last name, and write another measure for Last Name
My First Name = CALCULATE ( MAX ( Table[FirstName] ), ALLEXCEPT ( Table, Table[Id] ) )
