Тёмный

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

Excel Off The Grid
Подписаться 27 тыс.
Просмотров 8 тыс.
50% 1

★ 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

Опубликовано:

 

29 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@iantotheh
@iantotheh Год назад
This is the exact video I was looking for thank you!
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Glad it was helpful!
@arnaudallard3663
@arnaudallard3663 Месяц назад
Brillant
@kebincui
@kebincui Год назад
Brilliant tip. Thanks Mark👍👍
@kennethstephani692
@kennethstephani692 Год назад
Great video, Mark!
@huubpoppelaars7597
@huubpoppelaars7597 Год назад
Thanks Mark again a great tip
@SaberTech01
@SaberTech01 Год назад
Brilliant - exactly what I needed. Thanks
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
You're welcome! 😁
@BIGorilla
@BIGorilla Год назад
Great tip there, thanks Mark 🙏
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thanks Rick. As you know, M is such a different style of programming language. There are so many quirks just like this.
@iliesboukhatem7803
@iliesboukhatem7803 Год назад
a great video, thank you !
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Glad you liked it. 😁
@pancholitachiu23
@pancholitachiu23 Год назад
Great video, many thanks
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thank you 😀
@s18853a
@s18853a Год назад
amazing !! Mark Thank You
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thanks, I’m glad you enjoyed it.
@MrDhunpagla
@MrDhunpagla Год назад
Brilliant 👌 Thank you
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
You're welcome 😊
@julie_chen
@julie_chen Год назад
Really good learning videos 😊🙏
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thank you! Cheers!
@gregbernard7861
@gregbernard7861 Год назад
Pretty cool.
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thanks 😃
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
great content!
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Thank you. I’m glad you liked it.
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
@@ExcelOffTheGrid no doubt✌️
@ExcelWithChris
@ExcelWithChris 3 месяца назад
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
@johnfromireland7551 Год назад
And circular references....give an error.
@ExcelOffTheGrid
@ExcelOffTheGrid Год назад
Yes, they will.
@flinhadlee1944
@flinhadlee1944 Год назад
Pᵣₒmₒˢᵐ 😒
Далее
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
I Bet You Don't Know All These Power Query Tricks
12:28
Power Query - Faster & Easier Parameters
13:38
Просмотров 34 тыс.