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] ) )
parry2k
Super User
Super UserAnonymous 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] ) )