Forum Discussion

Lmendes's avatar
Lmendes
Frequent Visitor
7 years ago
Solved

Replace values

Hello I am struggling with two things to do with replacing values.    https://www.dropbox.com/s/0j792l4jlkfsigr/Replace%20values.pbix?dl=0 https://www.dropbox.com/s/vvedv43zubsptxh/Replace%20valu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I've replaced the value from "Aptiv" to "Karnataka"

 

But for some reason, I can still see "Aptiv" , similar to these there are many other values didnt change. Not sure why it didnt change.

 

I used Advanced Editor to change, I have provided the below code for your reference.

 

#"Replaced Value82" = Table.ReplaceValue(#"Replaced Value81","Aptiv ","Karnataka",Replacer.ReplaceText,{"State/Province"}),

 

Also another state name "Andhra Pradesh" repeating twice, I have used trimmed and clean columns before replacing the value but still no changes. Can somebody provide some inputs on this please.

 

  • dobregon's avatar
    dobregon
    Impactful Individual
    3 years ago

    it should work

    in any case you have another option. is to create a dataset with 2 columns, nameold and namenew and then in dax create a new column like finalname that check the newname

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for your quick response. Appreciate your solution. However, For some reason, I can still see the same result.