From the course: Advanced Power Query
Join today to access over 24,600 courses taught by industry experts.
Feed what Power Query eats
From the course: Advanced Power Query
Feed what Power Query eats
- I was in London last year at the Global Excel Summit to speak about Power Query's M language, but I had one challenge. How should I start my conversation that it hooks the audience, right from the first sentence that I say? And I came up with this lingo that I use it until today, and that lingo is, "Feed What Power Query Eats. And you might wonder, what does it even have to do with the things that we are learning in Power Query as of now? Well, let me show you how powerful as a concept is, "Feed what Power Query eats," using some concepts in Power Query. Let's start. This concept of "Feeding What Power Query Eats," is going to be super helpful to understand edit and debug formulas which are working and to be able to create more complicated queries on your own. Let's just start with a few examples. I have a table right here and I would like to work out something with the table, and I want to first load this table into Power Query. So I'm going to click anywhere on the table, go to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.