Reference an Intermediate Step from another Query | Power Query Tricks

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

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

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

===== CHAPTERS =====
0:00 Intro
0:30 Trick 1 - Jumble them up
4:26 Trick 2 - Split Queries
6:00 Trick 3 - Extract Query Steps
12:41 My Courses

===== 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!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[chandoo_]

That is RECORD Breaking...Awesome tricks Chandeep 🤩

[SteliKlnts]

Trick number 3 went over my head the first time I saw it. BUT NOW….. 🎉🎉🎉🎉 Only took me 60 painful hours to realize how vital this was. Thank you so much.

[buhogris]

The last trick is so damn fantastic! It looks so simple yet I wouldn’t ever thought about doing that approach. You made a great explanation on how records works, thank you!

[double-excel]

Incredible! I've wondered how to reference intermediate steps in other queries for a long time, nice to see this way of doing it! Just ran across your channel, and love your explanation style. Looking forward to digging through your old videos!

[lar]

Stunning trick, definitely comes handy in creating complex joins only at a particular stage .. Thank you for sharing Chandeep.

[thamilanban]

Thank you
Could you please post a video on how to use the last trick practically?

[KhalidKhans]

Great !!! Sir,
I was looking for such a Solution where we can access an already worked out process and avoid duplication and bunch of M Code in another query. This way we know exactly our logic is

Many Many Thanks to your Sir

Khalid Khan

[JonnyMacVA]

I fell off my seat with the last trick. Amazing. It shows the power of the M language and how it can provide wrappers for just about anything. Thanks Chandeep. Great job!

[alansnyder]

I love the last trick as a resource saving trick as well for two reasons. First, the flexibility. In one case I referenced the same table multiple times for different reasons and so they did not need to load all the applied steps every time. Being able to jump in at the first or second step saves so much confusion in the new tables because the unneeded steps are not there.

Second, when I refresh my data model, I noticed that the record refreshes very quickly since it is not actually unpacking the tables as a referenced table or duplicated table would. Instead, it loads the rows of instructions and unpack the table when it called as a source. Saving our team an entire table worth of time, memory, bandwidth for each table we use this technique and every time we refresh our models. It also helps keep the file size down if you need to use this trick multiple times in your data set. That was very important to us before the Query Folding pipelines were available.

[subanark]

Instead of creating a new query, entering in the name of your main query, and then clicking a table cell in there... In your main query, click the white space to the right of the Table link and choose "Add as new Query". Note that doing this will copy the main query meaning any chances you make to the main query will not be reflected in your new query. Alternatively, you can right click a query and choose reference, which is the same as creating a new blank query and entering the name of another one.

[BIGorilla]

That's fun way to transform steps into a record! I'm liking all this, and it's easy to implement, and to revert. Awesome!

[willianthalles]

This approach with Records is so cool. It can be helpful to avoid circular references. When you need to pick up an early step, manipulate it and after that add it to the final step of the Query A. This is awesome😊

[thiagofraletti]

Trick 3 was really a surprise! Really nice mate, keep going with the nice videos! Appreaciate the knowledge sharing!

[HachiAdachi]

🤯 This is a game changer! This may change how I will design my queries moving forward...

[jimbeverley]

Mind. Blown. Super helpful for understanding PQ in more depth. Thank you!!

[TheMarked]

I fixed my whole life with trick on 6:00. And I did indeed jumped off my chair at 11:00. It's so simple yet powerful.

[jaymehta]

No doubt - ABSOLUTELTY MINDBLOWING!!! The last one obviously amazing from the utility point of view. Thanks for sharing this.

[vli]

All the 3 tricks are super. Especially the 3rd trick to create new source from existing step of a query.
In the 2nd trick you shared reg extract previous to make separate query is also awesome. But it has a limitation I feel, you can't add further steps in the detail table since it becomes source for the original table.
Nicely explained and superb recording

[webwatcher]

This is amazing trick and I can see how I will use it in my work. Thank you Goodly. I start watching every lesson you have in the channel. Very impressive and really appreciate your work for teaching Power BI techniques.

[ianmacnz]

Excellent content. Thoughtful and enthusiastic delivery. Thank you sir!