I Bet You Don't Know All These Power Query Tricks

Here are seven mind-blowing Power Query tricks - Promoting headers without a promoted headers step, Extracting any Intermediary Step, Dynamically Expanding Tables, Projections, Sections Keyword, Is Keyword, and '&' Keyword!


===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[hashi]

The meta trick is awesome. I've been having to create a copy of the query any time I want to convert it into a list of records.

[jeromeastier]

Love the error! Seriously I might have known the first one, but the one that I really dig is the dynamic expand data.

[lynxwomancat]

Love the promoted header trick from null to true! Thank you so much for sharing your vast PQ knowledge with us!

[randomguy-jovq]

0:19 Promote Headers without step
1:28 Extract any intermediary step
4:00 Meta keyword
5:09 dynamic expansion of the tables
7:07 projections
8:18 sections keyword
9:18 is keyword
10:21 & Operator

[pianoquatrevingtquinze]

I've been using power query with the GUI for a few years now. Since I have been following you videos, I have made great progress. Thank you very much.
Also, I want to tell you that I love your style, it's a pleasure to follow you. Thank you!

[jake]

This channel is outstanding. Thanks for the efficient demos!

[johnlug]

I appreciate #7 the & join of tables; gives PQY a Union query if tables are prepared with Exact same header names. Because of these criteria, I was wondering if you have a trick to pick only certain columns by a list of numbers and to order desired columns in any preferred order ( 170, 2, 3, 4, 164, 15, 10) as column # listed in order desired. For complexity assume the #(cr) needs to be removed from the header row. I currently have about 9 Pwr Qry to do most of the work, but I have a second table that needs to update data rows from another source. That's why I like The AMPERSAND #7 tip.

[markusleucht]

WOW!

Occult Knowledge from the initiated. Worth every second.

Thanks so much for your hard work, Chandeep!

[sachin.tandon]

Very slickly and succintly presented. I also like the video clips of the brand and other areas that make the tutorial easier to follow. Makes it look very professional!

[jeromeastier]

Just used extract any steps + Dynamic Expand. Awsome!

[thebhaskarjoshi]

Wow... Amazing tricks
One Suggestion: Try to add time stamp in the description of each video. It'll help user to refer back any one point quickly for revision purpose later in time.

[zahoorsarbandi]

All tricks are amazing and very useful. Thanks for sharing.

[raimundojs]

Simply brilliant!!! "Expression.Error: WTF: This viewer is not Subscribed to your Channel" > now that would be a critical and unforgiven error!

[vinothe]

All new tricks I learned today is pretty awesome....
Thank you

[ashleehuff]

Very clever way to get viewers to subscribe to your channel, I laughed out loud... and then subscribed.

[flyingHubby]

Meta is awesome. Keep all the code, that creates multiple output objects, together in one place and refer to it from the outside. Great structure.

[girishsawant]

Thank you very much for sharing such valuable knowledge.

[comsavvy_ogp]

After watching this video, I have gained a better understanding of meta and is keywords. These tricks are amazing!

[barotkaushik]

You can have multiple metadata with the following syntax


meta [first = Source, second=FilteredData]

[MS-sbgv]

That “is” trick will be very useful. Can’t believe I haven’t used it before