Тёмный

Reference an Intermediate Step from another Query | Power Query Tricks 

Goodly
Подписаться 89 тыс.
Просмотров 48 тыс.
50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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
- Source: goo.gl/fh3rEJ​
Official After The Fall RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

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

 

27 июн 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 216   
@GoodlyChandeep
@GoodlyChandeep 7 месяцев назад
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
@chandoo_
@chandoo_ 2 года назад
That is RECORD Breaking...Awesome tricks Chandeep 🤩
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad to see you here Chandoo. Your puns never cease to amuse me! Thank you 😊
@dhananjaypinjan2643
@dhananjaypinjan2643 2 года назад
Nice to see Two Stars on one page 🙏👍👍
@culpritdesign
@culpritdesign 2 года назад
omg chandoo you're a legend. I remember using your excel tutorials a very long time ago!
@subanark
@subanark 2 года назад
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.
@buhogris
@buhogris 2 года назад
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!
@williamrhopkins
@williamrhopkins Год назад
Exactly how I felt!
@phillipkadaoui9649
@phillipkadaoui9649 Год назад
@@williamrhopkins same, absolute game changer
@double-excel
@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!
@thamilanban
@thamilanban 2 года назад
Thank you Could you please post a video on how to use the last trick practically?
@wayneedmondson1065
@wayneedmondson1065 2 года назад
Great! Thanks Chandeep. Thumbs up!!
@cherianiype
@cherianiype 2 года назад
Number 3 man!! Woot Woot!!!
@jimbeverley
@jimbeverley 8 месяцев назад
Mind. Blown. Super helpful for understanding PQ in more depth. Thank you!!
@spen2431
@spen2431 2 года назад
Brilliant. Very well explained. Thank You 🤯
@patrickharilantoraherinjat2994
@patrickharilantoraherinjat2994 2 года назад
Wow... Just Amazing. !!!
@thiagofraletti4220
@thiagofraletti4220 2 года назад
Trick 3 was really a surprise! Really nice mate, keep going with the nice videos! Appreaciate the knowledge sharing!
@kebincui
@kebincui 2 года назад
Mind blowing👍👍👍👍
@lar5091
@lar5091 2 года назад
Stunning trick, definitely comes handy in creating complex joins only at a particular stage .. Thank you for sharing Chandeep.
@nathanhoover5156
@nathanhoover5156 2 года назад
Excellent, didn't know the last one, very useful!
@HachiAdachi
@HachiAdachi 2 года назад
🤯 This is a game changer! This may change how I will design my queries moving forward...
@jaymehta3320
@jaymehta3320 2 года назад
No doubt - ABSOLUTELTY MINDBLOWING!!! The last one obviously amazing from the utility point of view. Thanks for sharing this.
@henrifanda4784
@henrifanda4784 2 года назад
so interesting. many thanks
@bravucod
@bravucod 2 года назад
Phenomenal!
@scoflix
@scoflix 4 месяца назад
Thanks ... it was really helpful! Best video so far!
@TrassBI
@TrassBI 2 года назад
Nice tricks!👏Thanks for sharing👍
@ianmacnz9045
@ianmacnz9045 Год назад
Excellent content. Thoughtful and enthusiastic delivery. Thank you sir!
@allanmachado2011
@allanmachado2011 Год назад
Last trick is awesome. Thank you!
@cg24356
@cg24356 2 года назад
Awesome!
@chamoore
@chamoore 2 года назад
the last one is mind blowing. this solves many problems. thank you mate 🙏
@sybarix
@sybarix 29 дней назад
Great tips bro, thanks
@Koopzy
@Koopzy 11 дней назад
that last one is actually insane and useful
@koustavbag3907
@koustavbag3907 2 года назад
I learned 3 new things today. thanks :D
@PranayPawar1991
@PranayPawar1991 3 месяца назад
Amazing Trick as usual, Thanks a lot. Cheers
@KhalidKhans55
@KhalidKhans55 Год назад
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
@santoshdevtale
@santoshdevtale 2 года назад
Always wait for your video
@JonnyMacVA
@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!
@GoodlyChandeep
@GoodlyChandeep Год назад
Great to hear!
@amitk1208
@amitk1208 2 года назад
Thanks for the video fantastic keep it up 👍
@BIGorilla
@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!
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks Rick!
@powerbinareal
@powerbinareal Год назад
#powerbinareal
@PowerMacro
@PowerMacro Год назад
Now I came to know, no one else can teache with so simple logics power query and BI without any additional fee
@sukoi2113
@sukoi2113 2 года назад
Mind Blown!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thank you 💚
@alansnyder6565
@alansnyder6565 8 месяцев назад
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.
@PedroCabraldaCamara
@PedroCabraldaCamara 2 года назад
this is crazy good!!! The 3rd one is fantastic!!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad you liked it
@hi55us2
@hi55us2 Год назад
So cool, thanks!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it!
@manamta9592
@manamta9592 Год назад
Excellent tricks Chandeep..mind blowing
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@vl21i
@vl21i 2 года назад
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
@sandeepjami9119
@sandeepjami9119 2 года назад
Great video mate
@udusegbe
@udusegbe 2 года назад
Love the 3rd trick! 😀👍 2nd trick looks similar to the 'reference' feature, but in reverse 🙂
@iankr
@iankr 2 месяца назад
Many thanks! Crazy...
@qiancasper
@qiancasper 2 года назад
Thanks for sharing its really blowing my minds
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad you enjoyed it
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
Great content. Thanks.
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it!
@RajKansagara
@RajKansagara 2 года назад
3rd one is the best and fantastic! Thanks for sharing!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thanks. Cheers
@ThanhNhandl
@ThanhNhandl 2 года назад
very helpful and crazy tricks, thanks for your sharing
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad it was helpful 😊
@AT-LT
@AT-LT Год назад
Thank you Chandeep, very useful to experiment with and find alternative query building options!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it
@workstuff5253
@workstuff5253 2 года назад
pretty cool for referencing!!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Totally!
@Wzxxx
@Wzxxx Год назад
Wow Just wow. I love this channel!
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks Wzx!
@shoryaarora1464
@shoryaarora1464 11 месяцев назад
Awesome
@janardhanansgm521
@janardhanansgm521 2 года назад
First Like chandoo..👌
@txreal2
@txreal2 Год назад
Insane!
@dianacruz7925
@dianacruz7925 Год назад
This is a great trick!! Saves so much time and make the query so efficient! Thanks
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad it was helpful Diana!
@excel-jodallah
@excel-jodallah Год назад
Really amazing
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks ✌️
@boominathanaara5599
@boominathanaara5599 Год назад
Yes in deed wonderful. This is what exactly shows up when we connect to sharepoint list and see the site contents
@jaybuddhadev3543
@jaybuddhadev3543 4 месяца назад
always Best👌
@willianthalles
@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😊
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like this Willian!
@celinemadore7059
@celinemadore7059 Год назад
You definitely are a champion Chandeep! I was litteraly pointing up just when you were explaining the transformation of steps in a record. It is just fabulous. I will rebuild some of my complex power queries to make them lighter. Great great great !
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks Celine!
@rhaps2008
@rhaps2008 Год назад
Awesome, that last Record trick is amazing thanks
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it Lucena!
@scottymac734
@scottymac734 2 года назад
Another excellent presentation! Cool to see Chandoo drop in with kudos as well.
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thank you! 💚
@maracuyapassionfruit
@maracuyapassionfruit 2 года назад
Maaaaate! really good trick! Thanks a lot!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad you liked it!
@maurocavalcante132
@maurocavalcante132 2 года назад
Wow !!!!
@scottcha03
@scottcha03 Год назад
This did not disappoint. All are brilliant, thank you. Love the outtake at the end
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@kadirkkkk
@kadirkkkk Год назад
it seems so useful bu we also should check the performance of the queries
@webwatcher188
@webwatcher188 Год назад
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.
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you, John!
@Paladin101
@Paladin101 14 дней назад
I know this is old but then I'm an old guy playing with code - this if fun Chandeep - thanks buddy. 😉
@KawanExcel
@KawanExcel 2 года назад
AS always... Ppfffff... Mind blowing
@arunkumarkesavan6077
@arunkumarkesavan6077 Год назад
Awsome bro😄
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks !
@IlaPatel811
@IlaPatel811 Год назад
Loved the 3rd Trick
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks 💚💚
@vineetyoutubr5
@vineetyoutubr5 2 года назад
I really liked 3rd trick. Thank you Chandeep. You are awesome. lots of love.
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thank you so much 😀
@Edbird
@Edbird 2 года назад
That third trick goes straight into my utility belt 😎 Thanks, Chandeep!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad you found it helpful Eddie!
@vigneshahob
@vigneshahob 2 года назад
Geezzz..!!! That was super cool Chandeep..! I was laughing and enjoying for 5 min.. :D
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thank you so much 😀 You laughed and enjoyed.
@sanmaj100
@sanmaj100 Год назад
Wow Wow Wow Wow You have solved my one problem by using the last technique I can dynamically execute or not to execute the query. Awsome trick
@GoodlyChandeep
@GoodlyChandeep Год назад
Cool! 💚
@bartwy5676
@bartwy5676 Год назад
First trick was nice, but third is mind blowing. Question is impact on performance in complex queries. Would have to check it ;)
@YvesAustin
@YvesAustin 10 месяцев назад
Cant wait to jumble up my queries😂. Amazing last trick! I reference queries a lot and split them as your trick #2, but had never seen that third one. Thank you.
@keagankemp6275
@keagankemp6275 2 года назад
Wow mind blown 🤯, you are legend, got out of bed just to try the last trick lol 😂
@LimeulVincent
@LimeulVincent Год назад
Hi, your videos are very interesting and I often learn new stuff but stop constantly teasing on what comes next, we are here for one reason and we stay with you 😉. Vincent from Paris
@BrainyBrunetteBarbie
@BrainyBrunetteBarbie 2 года назад
“Wackiness Quotient” LOL Just found your channel, so awesome! Thank you for the wonderful information!!
@sbn4862
@sbn4862 2 года назад
Yes, PowerQuery master tabling
@gauravsukhadia638
@gauravsukhadia638 Год назад
Loved 3rd trick
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@odekunleodebiyiomotayo6690
@odekunleodebiyiomotayo6690 Год назад
the last trick is really incredible, well done. but my question is what happens when you have additional information in the source file? if you refresh, will the new record pick the new information?
@yemiakinwande7039
@yemiakinwande7039 11 месяцев назад
Thanks Chandeep - third trick is awesome. This shows how to reference the query steps/records you've created at the beginning of a new query (as the source). But instead, how would you refer it in the middle of the new query (as a single value to be used in a calculation or Custom column)?
@mittenwald3679
@mittenwald3679 Год назад
genius bro !!!!!
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@chengwang411
@chengwang411 2 года назад
great stuff. i'm definitely gonna use it to prank some workmates. 😄
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Haha..cool! 🙃
@thebhaskarjoshi
@thebhaskarjoshi 2 года назад
Trick 3 was really a surprise!
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Thanks 💚
@GeertDelmulle
@GeertDelmulle 2 года назад
Your final trick really is rad! :-) I think I’ll find a good use for that. Thanks for sharing!
@GeertDelmulle
@GeertDelmulle 2 года назад
OK, I just thought of something: I have this query where I look up the help on all the built-in functions, and then I subsequently I filter that “source” step for bunch of keywords like “Table”, “List”,… So, now you know that in the very near future I will have the capability to ask for Help[Table] anywhere and get exactly what I want… ;-)
@GoodlyChandeep
@GoodlyChandeep 2 года назад
@@GeertDelmulle I post more relevant uses of this trick soon. One video at a time :)
@GeertDelmulle
@GeertDelmulle 2 года назад
PS: works like a charm! (of course it does :-)
@rajanpradeepankarath8846
@rajanpradeepankarath8846 2 месяца назад
Record indeed. Chandoo has spoken, what more can I say
@kassiowifried
@kassiowifried 2 года назад
Thanks you
@AnAnd-zl7oo
@AnAnd-zl7oo 2 года назад
Mind blowing 🤯... literally feel what ever I had learnt basics about MCode....out of my mind 🙃
@huynhdinhtuananh
@huynhdinhtuananh Год назад
Greatttt
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@reanalytics1863
@reanalytics1863 2 года назад
I think he third trick is really crazy🤭🤭🤭🤭🤭 but I am still trying to pick up good use cases for the trick I hope you make a video with some examples on how to gain from the third trick🤟🤟🤟
@powerbinareal
@powerbinareal Год назад
Muito top!!!!!!!!! Very cool! I hope one day to exchange many ideas with you! #powerbinareal
@user-tj6fq7fr5s
@user-tj6fq7fr5s 4 месяца назад
More pivot table tips and tricks please 😊
@sanglee9937
@sanglee9937 Год назад
This is awesome!!! Just a quick quesiton on the third method. Would doing that when you have so many steps with a large dataset slowdown Power BI?
@GoodlyChandeep
@GoodlyChandeep Год назад
I doubt that converting the steps into records would slow them down. It should not impact the speed unless there is a problem with the step itself. I haven't tested it thoroughly with very large data. With a couple of million rows it works fine!
@narasimhaprasad847
@narasimhaprasad847 Год назад
Super trick
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@GrainneDuggan_Excel
@GrainneDuggan_Excel 2 года назад
Wacky, but useful trick Chandeep - Thanks
@jameszhou162
@jameszhou162 Год назад
hey Chandeep, high appreciate this trick! i helped my wife with her analysis on a survey which has many parts to be individually analyzed. i used reference or duplicate but found the query quickly turned into giant mess. this is very helpful to pick up the step i need
@GoodlyChandeep
@GoodlyChandeep Год назад
Great 👍
@muralidharannatarajan4251
@muralidharannatarajan4251 Год назад
Super
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@julie_chen
@julie_chen Год назад
I’ve saved this into my library folder named Bananas (Guy in Cube’s Phrase).😊
Далее
Split by Variable Columns in Power Query
13:38
Просмотров 27 тыс.
5 Surprising Power Query Tricks You Need to Know!
14:14
Самоприкорм с сестрой 😂
00:19
Просмотров 183 тыс.
The Magic of working with Records in Power Query
10:28
5 Tricks to Reduce Steps in Power Query
16:41
Просмотров 32 тыс.
List.Accumulate in Power Query with Practical Examples
27:26
FullHD в 8К БЕЗ ПОТЕРЬ? |РАЗБОР
20:42