Power Query - Conditionally replace values in one step!
Replacing Values in a column is a common requirement and you'll run into it a lot in real world data. But it usually (not using advanced editor) takes couple of steps to get the values replaced. In this video i show you how to do it in one step using a bit of m-query in the advanced editor.
#mquery #powerquery #excel #data #dataanalytics #datacleaning #powerbi #powerbidesktop
Links
Sample File used in Video
https://github.com/jbotes/powerbiTuto...
my site
https://www.basensei.com/
Mquery Link
https://learn.microsoft.com/en-us/pow...