Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥
a brilliant explanation of Custom Function. I would honestly suggest that a learner of Power Query must watch this video for learning Custom Function.👌👍
Love your videos...here's a thought...how about adding a bonus example to select (all?) videos. It would not contain the same exact steps, but related. In this video, you could have a data set that manipulates the data in some other way, like calculating the length of time it takes from the purchase date to the delivery date, for example. Then, give it to your watchers to try on their own, with a solution in a week or two or whatever (a little homework assignment). It would give the user a chance to try what they have learned in a new example. Just an idea. You are doing a great job and providing a wonderful service to the community. Congratulations.
Dear Miss MS, I wanna ask a small question please. @ 8:40 if the source data is a spreadsheet instead of a table what would be the type instead of 'table' i.e. (SalesData as xxxxxx)? Appreciate your response. Thank You.
Hi there, I really liked your video and have subscribed. I have been going down a rabbit hole trying to wrap my head around functions, and this has been one of the more insightful and practical examples. Can I ask that you might make the files available to work on? I really like to be able to follow along to help cement my understanding.
I'm so glad to hear that the video is helpful! Please see the practice file, hope it helps: docs.google.com/spreadsheets/d/14VYXhP-3c88Ai9bx6TgEDphc9wohrwSd/edit?usp=share_link&ouid=108573460979392589182&rtpof=true&sd=true
👋 hi ..actually, good ideas but could you distribute all functions which used into shortage videos To help me understand easier and explain each function speartly plz
@eslamfahmy3541 I've created these videos here that are shorter and focus on one concept at a time, please check them out, hope they help: ua-cam.com/video/kqHMP0OzzBo/v-deo.html ua-cam.com/video/eSbHsZQhmE0/v-deo.html ua-cam.com/video/K_N2Rj6wVfE/v-deo.html ua-cam.com/video/cgjsJkMm8ME/v-deo.html
Hi David, I’ve removed the music from my subsequent videos, please check and let me know if this is better: ua-cam.com/video/Dwet7lMBvos/v-deo.htmlsi=XafWjYlzhfjKWvD2
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe
🚀🔥
Nicely explained! Thank you very much.
a brilliant explanation of Custom Function. I would honestly suggest that a learner of Power Query must watch this video for learning Custom Function.👌👍
Thank you so much for your support Zahoor! 😀
Great video. Like the way you have selected a small dataset, just large enough to demonstrate the principle. Thank you.
Dear Miss M.,
super, great. Your explanation is great and I can follow, even I am not an PQ expert.
I’m glad to hear Norbert!
Amazing video... Learned about power query. Good work!
Thank you Premjit :)
Great explanation, you’re a very good teacher!
Thank you!
@barttrudeau9237 thank you for the coffees! You made my day ☕️☕️☕️
Love your videos...here's a thought...how about adding a bonus example to select (all?) videos. It would not contain the same exact steps, but related. In this video, you could have a data set that manipulates the data in some other way, like calculating the length of time it takes from the purchase date to the delivery date, for example. Then, give it to your watchers to try on their own, with a solution in a week or two or whatever (a little homework assignment). It would give the user a chance to try what they have learned in a new example. Just an idea. You are doing a great job and providing a wonderful service to the community. Congratulations.
Thank you so much dravetch for your kind words and for the suggestion! I've added it to my plans for the channel, thanks!
Learnt a lot here, thank you!
Glad it was helpful!
Very helpful, learned some great tricks in this video
Glad it was helpful J!
Very nicely explained and presented.
Thank you!
Very useful! Thank you!
Glad to hear Florin :)
Dear Miss M.,
great, super and thanks.
You're welcome Norbet :)
Thank you for this helpful video.👋
Absolutely brilliant video !! Thank you so much.
You're most welcome! Glad it was helpful :)
Dear Miss MS, I wanna ask a small question please. @ 8:40 if the source data is a spreadsheet instead of a table what would be the type instead of 'table' i.e. (SalesData as xxxxxx)? Appreciate your response. Thank You.
Because your data will get import to power query by converting in to tables so y she is using as table
Sensacional...muito obrigado!!! Parabéns pelo trabalho!!!
You’re most welcome! I’m glad the video was helpful 😊
Hi there, I really liked your video and have subscribed. I have been going down a rabbit hole trying to wrap my head around functions, and this has been one of the more insightful and practical examples. Can I ask that you might make the files available to work on? I really like to be able to follow along to help cement my understanding.
I'm so glad to hear that the video is helpful! Please see the practice file, hope it helps: docs.google.com/spreadsheets/d/14VYXhP-3c88Ai9bx6TgEDphc9wohrwSd/edit?usp=share_link&ouid=108573460979392589182&rtpof=true&sd=true
Great video n PQ! Do more like this videos with Custom Fx, or reusable Fx and so on =)
Thank you! Stay tuned there will be more :)
Thank you. Subscribed.
Awesome, thank you Thamil!
Superb 👌 video Miss
Thank you!
@@MissMicrosoft you’re always welcome 🤗
@@MissMicrosoft but I need to tell you thank you for giving such a wonderful content 😌 In power query
It’s my pleasure! Just glad it’s helpful 😊
@@MissMicrosoft that so nice 😊
Amazing tips thanks so much
You're so welcome!
Excellent Thanks 🌹🌹👍👍
Thank you Kebin :)
Thank you!👍🤛💯
You're most welcome!
👋 hi ..actually, good ideas but could you distribute all functions which used into shortage videos
To help me understand easier and explain each function speartly plz
I will do my best :)
@@MissMicrosoft thanks a lot
@eslamfahmy3541 I've created these videos here that are shorter and focus on one concept at a time, please check them out, hope they help: ua-cam.com/video/kqHMP0OzzBo/v-deo.html
ua-cam.com/video/eSbHsZQhmE0/v-deo.html
ua-cam.com/video/K_N2Rj6wVfE/v-deo.html
ua-cam.com/video/cgjsJkMm8ME/v-deo.html
@@MissMicrosoft thanks a lot 🙏
Good tips
Thank you, glad it was helpful!
The background music is annoying and distracting.
Hi David, I’ve removed the music from my subsequent videos, please check and let me know if this is better: ua-cam.com/video/Dwet7lMBvos/v-deo.htmlsi=XafWjYlzhfjKWvD2
on point, Thank you so much
You are so welcome 🙌