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 Wil...
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] ) )
Nathaniel_C
Community Champion
Community ChampionAnonymous ,
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.
Nathaniel