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

my site

Mquery Link

[ponli]

First video I saw of you, great job. Love the way you broke down each step and showed output. Really made it easier to understand the syntax.

[stephencross]

Great video, thank you !!
How can I replace the beginning key in the value, but not the data - some something like P66/YKNA and I only want to keep the YKNA?

[QasimAli-gynb]

James can you do a videos series on consolidation in Power query with the following topics, please.

Consolidation of Data using Ms-Excel

A) In the case of datasets are at the same position in every sheet

B) In the case of datasets at different positions on different sheets

C) In the case of datasets from different Workbooks
D) End-to-End usage of Consolidate Feature
E) End to End usage of 3D SUM
F) Consolidation functionality in Pivot Tables

3) Consolidation of Data using Power Query of Ms-Excel

A) Datasets from all the sheets of the same workbook

B) Datasets from different workbooks

C) Datasets from all the Sheets of All Workbooks
D) Datasets from PDF tables
C) All CSV/Text Files in a Folder
D) All Excel Files in a Folder
E) All Excel Files in Subfolders of Parent Folders.

[SamehRSameh]

Can i apply this on multiple columns at once ?

[daremo]

Hi! I have question, how i can in Power BI find any symbol?
I search sth like % in SQL.