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
Lmendes's avatar
Lmendes
Frequent Visitor
7 years ago

Hi

 

Thanks so much for your advice. I am familiar with the replace values step unfortunately I have to do this for several columns and responses so it would take me quite a while. It would be much more efficent for me to be able to replace one value and use else for all others.

 

Thank you

Laura

  • Lmendes's avatar
    Lmendes
    Frequent Visitor
    7 years ago

    Brilliant thanks so much!

     

    Just a pointer for learners (like me). I had to include [Q3] as [#"Q3"] and [Q2] as [#"Q2"] etc.... for it to work. But it now works like a dream :)