Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Substitute multiple values in one column via DAX

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,
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)