Perform a Case Insensitive Replace Values in Power Query
This video teaches how you can replace values while ignoring case. This method has a big benefit over the regular replace method that needs an exact match. Performing the case insensitive replace of values allows you to create a robust replace action without the need to clean your data.
WRITTEN BLOGPOST:
The ultimate guide to replacing values in Power Query, find it here:
https://gorilla.bi/power-query/replac...
Master Functions and Syntax in M
https://powerquery.how
If you enjoyed this, there's another video you should see. It teaches you how to replace a value based on a condition: • Replace Values Based on Condition (in...
Chapters:
00:00 Introduction
00:15 The Issue with Regular Replace
01:24 Replace Case-insensitive in Custom Column
05:02 Replace Values and Ignore Case in Single Step
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#Replace #PowerQuery #BIGorilla