Merge different spellings in same column

[azad_neenan]

A field in one column has various spellings of the same item...is there a measure i can use during transformation to merge them into the same spelling?

[v-kkf-msft · Accepted solution]

Hi @azad_neenan ,

Please try the following measure:

Measure = 
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( 'Table'[spellings] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Items] = MAX ( 'Table'[Items] ) )
    ),
    'Table'[spellings],
    ", "
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[truptis]

Hi @azad_neenan , 

You can add a new conditional column and select the conditions as "contains" and few letters of the column and give the desired spelling you wish to give.

& Then apply and close.

@azad_neenan -> let me know if it works by marking it as a solution else show me an example of what values you wish to replace and i can help you with the conditions.