Forum Discussion
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...
In powerBI you can do using the commands automatically.
In the query editor window you have the option in tab transform to "replace values". you need to do
- Select the column that you want to analyze
- Click on replace columns
- Write the condition
Maybe you need to do this for each condition that you have. Automatically the powerbi will write this in the M query.
Same for second point
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
