У нас вы можете посмотреть бесплатно Check if Column Contains Item from List in Power Query - Create Text.ContainsAny! или скачать в максимальном доступном качестве, которое было загружено на ютуб. Для скачивания выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса savevideohd.ru
This video shows how you can create a condition to check for multiple substrings in a string. In other words to test if a value contains any of multiple items. It is very similar to the Text.Contains function, with the main difference that the shown methods are able to deal with multiple substrings. It's like a Text.ContainAny function to check if text contains one of many strings. Master Functions and Syntax in M https://powerquery.how If you need to perform an exact match, check out my other video: • Filter Column by List Items (Exact Ma... Chapters: 0:00 Intro 0:22 Recap: exact match 0:56 Method 1: Splitter.SplitTextByAnyDelimiter 4:01 The issue with Text.Contains 4:50 Method 2: Leverage Text.Contains in a function 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! #TextContains #PowerQuery #BIGorilla