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...
dobregon
Impactful Individual
Impactful IndividualIn 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
