All Content
explore our new search
Search for multiple keywords in one column using Power Query
Power BI
Oct 11, 2022 6:00 AM

Search for multiple keywords in one column using Power Query

by HubSite 365 about Curbal

Data AnalyticsPower BILearning Selection

If you need to search and find for multiple keywords in one column in Power Query, here is a very straight forward way to do that :)

Download the Sample Document

Power Query Functions Overview

The Power Query M function reference includes articles for each of the over 700 functions. These reference articles are auto-generated from in-product help.

Power Query Custom Functions

If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically takes some input and gives you an output.

How to Uncover the Hidden Power Query Function List!

Hidden inside both Excel and Power BI is a secret Power Query function list that you can bring up while working in the Power Query editor window…that’s if you know the magic word.

Parameters and Functions in Power BI / Power Query–Custom Functions

Power Query has over 600 native functions and the Power Query team keeps adding more and more.

I wouldn’t recommend memorizing them, but you do need to understand the concept of parameters and arguments in order to understand what functions are.

More about Power BI