Скачать или смотреть 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 a Si...  

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