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...
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)

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)