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.