Hellow guys, Welcome to my website, and you are watching Check if Column Contains Item from List in Power Query - Create Text.ContainsAny!. and this vIdeo is uploaded by BI Gorilla at 2021-09-01T04:24:23-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Check if Column Contains Item from List in Power Query - Create Text.ContainsAny! |
| Video Uploader | Video From BI Gorilla |
| Upload Date | This Video Uploaded At 01-09-2021 11:24:23 |
| Video Discription | 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: https://youtu.be/KnvSAAqfUX0 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_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #TextContains #PowerQuery #BIGorilla |
| Category | Education |
| Tags | power bi desktop tutorials for beginners | power bi desktop | power bi desktop tutorial | power bi | business intelligence | power query | power query tutorial | power query for beginners | text.contains | table.selectrows | value contains list item | text.contains multiple items | contains multiple substrings | contains substring | filter from list | power query filter list | filter using list | power query filter column contains list | list as filter argument | filter column based on list |
