Reference other steps in Power Query | Amazing transformation technique | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ About this video ★
This video demonstrates how to reference other steps in Power Query. This can help to simplify some difficult transformations.
0:00 Introduction
0:59 Referencing earlier steps
3:12 Referencing later steps
4:30 Referencing individual values on previous steps
6:59 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #PowerQuery

[@kebincui]

Brilliant tip. Thanks Mark👍👍

[@kennethstephani692]

Great video, Mark!

[@iantotheh]

This is the exact video I was looking for thank you!

[@ExcelOffTheGrid]

Glad it was helpful!

[@arnaudallard3663]

Brillant

[@huubpoppelaars7597]

Thanks Mark again a great tip

[@SaberTech01]

Brilliant - exactly what I needed. Thanks

[@ExcelOffTheGrid]

You're welcome! 😁

[@BIGorilla]

Great tip there, thanks Mark 🙏

[@ExcelOffTheGrid]

Thanks Rick.
As you know, M is such a different style of programming language. There are so many quirks just like this.

[@pancholitachiu23]

Great video, many thanks

[@ExcelOffTheGrid]

Thank you 😀

[@iliesboukhatem7803]

a great video, thank you !

[@ExcelOffTheGrid]

Glad you liked it. 😁

[@MrDhunpagla]

Brilliant 👌 Thank you

[@ExcelOffTheGrid]

You're welcome 😊

[@s18853a]

amazing !! Mark Thank You

[@ExcelOffTheGrid]

Thanks, I’m glad you enjoyed it.

[@julie_chen]

Really good learning videos 😊🙏

[@ExcelOffTheGrid]

Thank you! Cheers!

[@gregbernard7861]

Pretty cool.

[@ExcelOffTheGrid]

Thanks 😃

[@FRANKWHITE1996]

great content!

[@ExcelOffTheGrid]

Thank you. I’m glad you liked it.

[@FRANKWHITE1996]

@@ExcelOffTheGrid no doubt✌️

[@ExcelWithChris]

Please please help. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

[@johnfromireland7551]

And circular references....give an error.

[@ExcelOffTheGrid]

Yes, they will.

[@flinhadlee1944]

Pᵣₒmₒˢᵐ 😒