From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Pattern matching in Power Query

Pattern matching in Power Query - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Pattern matching in Power Query

“

- [Instructor] Within Power BI, we can utilize a number of tricks to help us more efficiently set up and analyze data with our models. One approach is by using pattern matching, where algorithms try to find patterns using sequences of steps. Unlike pattern recognition algorithms that AI and machine learning models use, for example, these matches are exact ones. Pattern matching algorithms typically find either sequences, like concatenation, or tree structures, like if-else conditions. Let's start with a set of inputs in a data table. We can map these inputs to a known output. However, without writing out an explicit formula to convert the inputs into this output, we don't know what sequence of steps it took to produce this label. We can, however, use pattern matching algorithms to create a recipe with a sequence of steps to link the inputs to the output. Now, let's say we have another set of inputs in our data. We…

Contents