Substitute multiple values in one column via DAX

[Anonymous]

Is it possible to create a DAX query to add a new column to substitute a company name for the letters "UK"?

I've used an example that might work with m language but I'm looking for a DAX query to convert up to 9 company names to just "UK"

SUBSTITUTE (SUBSTITUTE(SUBSTITUTE('looker_views lkr_Company_Supplier'[Company_Supplier_Name] “Company A”, “UK”), “Company B”, “UK”), “Company C”, “UK”)

Thanks,

[harshnathani · Accepted solution]

Hi @Anonymous ,

Please use this Calculated Column

IF('looker_views lkr_Company_Supplier'[Company_Supplier_Name]  IN {"CompanyA", "CompanyB","CompanyC"}, SUBSTITUTE('looker_views lkr_Company_Supplier'[Company_Supplier_Name],'looker_views lkr_Company_Supplier'[Company_Supplier_Name],"UK"))

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)