Forum Discussion

lnayak's avatar
lnayak
Frequent Visitor
4 years ago
Solved

Replace multiple values in one step using DAX

Hi All,   I have a company column with multiple common text ending with "Ltd", "Limited", "Inc", "Ltd.", "Company". I want to create a single DAX function to remove/replace these text with blank an...
  • BeaBF's avatar
    BeaBF
    4 years ago

    lnayak Hi!

    Try with this step:

     

    #"Substitute" = Table.TransformColumns(PREVIOUS STEP,{{"COLUMN NAME", each List.Accumulate({{"Ltd",""},{"Limited",""},{"Inc",""},{"Ltd.",""},{"Company",""}},_,(string,replace) => Text.Replace(string,replace{0},replace{1}))}})

     

    BF

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I don't know - it could be possible in Dax.

The Tutorial Video shows how this is possible - albeit in M (Data Transformation)