How to Uncover the Hidden Power Query Function List!

Рет қаралды 35,567

Күн бұрын

Hidden inside both Excel and Power BI is a secret Power Query function list that you can bring up while working in the Power Query editor window…that’s if you know the magic word.
Download the example file here: www.myonlinetraininghub.com/s...
0:18 The objective
0:39 Generating function list
1:08 Converting list to a Table
1:54 1st way to use function list - Reference
2:29 2nd way to use function list - Custom Function
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy

Пікірлер: 130

@vijayarjunwadkar 3 жыл бұрын

Thank you Mynda, while I knew this technique, the conversion to table and creating a custom function was new to me! Great tutorial as usual! 😊👍

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it, Vijay!

@shoaibrehman9988 3 жыл бұрын

After watching it i am more confident to use custom function more frequently. Thanks a lot to share your knowledge.

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear 😊

@megamundus 3 жыл бұрын

Dear Lady, as always, a pioneer ! thank you

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure 😊

@makisalimhussain2334 3 жыл бұрын

Awesome Minda as always, I know how to get to the list of functions, but this is the first time I knew how to deal with it. Maki Baghdad-Iraq

@MyOnlineTrainingHub 3 жыл бұрын

Glad it was helpful, Maki!

@Fabi_terra 4 ай бұрын

Thanks, Mynda! Great tutorial and tips! 🙃

@MyOnlineTrainingHub 4 ай бұрын

Glad it was helpful!

@josecarlosconejo5724 3 жыл бұрын

Thank you very much! Love your lessons. You are a great teacher 👩‍🏫

@MyOnlineTrainingHub 3 жыл бұрын

Glad you like them!

@johnborg5419 3 жыл бұрын

Thanks Mynda. Never new that it was that easy!!! : )

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it, John!

@jerrydellasala7643 3 жыл бұрын

One of the best (if not THE best) Power Query tips I've seen, and I've seen a LOT of PQ Videos! Thanks!!!

@MyOnlineTrainingHub 3 жыл бұрын

Wow! So pleased you found it helpful, Jerry!

@SusithJayamanne 3 жыл бұрын

Wow this is super useful! Thanks Mynda

@MyOnlineTrainingHub 3 жыл бұрын

You're most welcome, Susith!

@ildikojanosi7099 3 жыл бұрын

Love it Minda! Thank you!

@MyOnlineTrainingHub 3 жыл бұрын

Glad you like it :-)

@thierrybernot9369 3 жыл бұрын

Brilliant. Thank you Mynda.

@MyOnlineTrainingHub 3 жыл бұрын

Thanks so much, Thierry!

@martyc5674 3 жыл бұрын

Brilliant- knew about the #shared but the create custom function direct from the list is new to me- it will accelerate my use of custom functions for sure.

@MyOnlineTrainingHub 3 жыл бұрын

So pleased it was helpful!

@pietercox1640 3 жыл бұрын

Really useful - thanks Mynda!

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear, Pieter!

@realpulsecoin 3 жыл бұрын

Great content! Love the custom function trick 👏🌞

@MyOnlineTrainingHub 3 жыл бұрын

Thanks, Rasmus!

@hemanttrivedi898 3 жыл бұрын

Nice Very Useful. Thanks Mynda

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear, Hemant!

@darrylmorgan 3 жыл бұрын

Hi Mynda!Really Great Tip..Thank You :)

@MyOnlineTrainingHub 3 жыл бұрын

Cheers, Darryl! 😊

@zzzzzzzzzzzzzzzz9 2 жыл бұрын

Ohhh wow. The list and creation of custom function

@MyOnlineTrainingHub 2 жыл бұрын

Glad you liked it!

@AZGATOR2002 3 жыл бұрын

This video is a game changer for me, thank you so much!

@MyOnlineTrainingHub 3 жыл бұрын

Awesome to hear 😊

@cherianiype 3 жыл бұрын

Oof!! Simple and deadly shortcut! Very many thanks again Mynda and team!

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure, Cherian!

@donjuan3887 3 жыл бұрын

Thank you for saving some of my time at work

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure, John!

@michaelbishop1684 2 жыл бұрын

Thank you so much! This was so helpful

@MyOnlineTrainingHub 2 жыл бұрын

You're so welcome!

@Oprimaita 3 жыл бұрын

Great tutorial as usual ! Thanks a lot !

@MyOnlineTrainingHub 3 жыл бұрын

Thank you 😊

@superlbc 3 жыл бұрын

Very useful, thank you! Love your content

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear 😊

@clickbisi7016 3 жыл бұрын

Ohhhhh, that’s how it works.. real pro level stuff here 👌🏾👌🏾

@MyOnlineTrainingHub 3 жыл бұрын

:-) glad you liked it!

@simonheard5975 3 жыл бұрын

I've been thrown in to the world of Power BI with no training so your videos have been invaluable. Please create a video on how to use zip files in Power BI without having to unzip them. Thank you.

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear, Simon 😊 You can’t import zipped files. They must be unzipped first.

@MrEagle1982 3 жыл бұрын

Awesome, I can easily see my lazy self using this feature to create custom functions more often than actually required! 😜 Also, it might be worth to add the syntax in description of this video.

@MyOnlineTrainingHub 3 жыл бұрын

Glad it’ll be useful, Imran 😊

@phanlekhai 3 жыл бұрын

Thanks your sharing. That is what i looking for the all the time.

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear 😊

@chrism9037 3 жыл бұрын

Awesome Mynda!

@MyOnlineTrainingHub 3 жыл бұрын

Cheers, Chris 😊

@bipower6915 3 жыл бұрын

Didn't know about this option, thx!

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure 😊

@rsn29sep 3 жыл бұрын

Yet another powerful lesson

@MyOnlineTrainingHub 3 жыл бұрын

😊 thank you!

@davideluccarini9856 3 жыл бұрын

Nice videos, You can make a video where you can show how you can create an interactive table with the current time. For example, you already put schedules if it has already passed it tells you closed while when it is present it tells you open. Thank you very much

@MyOnlineTrainingHub 3 жыл бұрын

Thanks, Davide! You can use conditional formatting to highlight due/overdue dates.

@advrohitowhal9794 3 жыл бұрын

THANKS MA'AM. IT IS VERY POWERFULL AS IT'S NAME "POWER QUERY"!

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it 😊

@hamidsh4789 3 жыл бұрын

Excellent as usual. Many Thanks.

@MyOnlineTrainingHub 3 жыл бұрын

Thanks again, Hamid!

@Dev_Bartwal 3 жыл бұрын

Great one.... Lots of loves from India

@MyOnlineTrainingHub 3 жыл бұрын

Thanks so much!

@DrK99999 3 жыл бұрын

So cool, Mam.one of the best videos for power query :)👍

@MyOnlineTrainingHub 3 жыл бұрын

Glad you think so!

@clivepetty2338 3 жыл бұрын

Thanks a very useful. Question, what is best way map Excel functions for example Trim to Power Query.

@MyOnlineTrainingHub 3 жыл бұрын

I don’t know of a mapping resource as such, but usually I just look for the function as shown In the video and if that doesn’t work, then Google it 😉

@kennethstephani692 2 жыл бұрын

Great Video!

@MyOnlineTrainingHub 2 жыл бұрын

Glad you enjoyed it 😊

@abdullah_alhathloul_ 3 жыл бұрын

very useful , thanks

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear 😊

@Anonom2012 2 жыл бұрын

I am now overwhelmed.

@MyOnlineTrainingHub 2 жыл бұрын

Hopefully in a good way 😊

@IvanCortinas_ES 3 жыл бұрын

I knew the shortcut of using #share. But thank you very much for the explanation of the function Date.IsInCurrentYear Thankful for your explanations on Power Query functions. It is a very interesting topic.

@MyOnlineTrainingHub 3 жыл бұрын

Glad it was helpful, Ivan!

@joaquimcosta952 6 ай бұрын

Very good...

@MyOnlineTrainingHub 6 ай бұрын

Thank you! Cheers!

@SMH2007 3 жыл бұрын

I forgot to mention I am using Excel 2019. I just download your workbook and key in =#shared, it works. but it does not work with my excel 2019.

@jawadahmadehssan6251 3 жыл бұрын

Thank you so much, as always your videos are awesome.

@MyOnlineTrainingHub 3 жыл бұрын

Thank you 😊

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it 😊

@Innovatell 3 жыл бұрын

This is great. Do you do consulting? I need quick advise on what path to take for what I do daily with my report and daily routines I do manually. Is that possible??

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it 😊 I don’t do consulting but if you get in touch via email I can give you the contact details of someone who can help you. Website at MyOnlineTrainingHub.com

@Innovatell 3 жыл бұрын

@@MyOnlineTrainingHub thank you. So just email you at the info email to your website? “‘MyonlineTrainingHub” ?

@MyOnlineTrainingHub 3 жыл бұрын

I don't see an email from you.

@seshakv 3 жыл бұрын

Thank you

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure 😊

@m.raedallulu4166 2 жыл бұрын

That was power smart!

@MyOnlineTrainingHub 2 жыл бұрын

:-) thanks!

@filipbednarz8429 2 жыл бұрын

How can I find the earliest date if I have a criteria using power query? In this case my criteria is Item Number and any give part number can show up in multiple rows. I'm new to power query and I keep trying to think of ifs or if(and) statements but I'm failing badly. It gets more complicated but I just want to start with one problem and solve part to later.

@MyOnlineTrainingHub 2 жыл бұрын

Hi Filip, Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@pardawala_Bhiwandi 2 жыл бұрын

It's amezing

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much!

@chiragbc 2 жыл бұрын

Why doesn't my Power query formula bar autofill when I start typing function name to recommend accordingly. I am using Microsoft Office Home and Student 2019 version

@MyOnlineTrainingHub 2 жыл бұрын

This is a new feature only available with a Microsoft 365 license.

@Nicolas-jx3oo 2 жыл бұрын

Amazing

@MyOnlineTrainingHub 2 жыл бұрын

Thank you! Cheers!

@Anil2881985 2 жыл бұрын

Dear Ms Mynda. i am using your channel to learn more on excel and especially power query. need to make this power query custamised. not able to get that done. could you please let me know how to contact you to get.your.help

@MyOnlineTrainingHub 2 жыл бұрын

Please post your question and sample Excel file on our forum where we can help you: www.myonlinetraininghub.com/excel-forum

@ChrisHedlund 3 жыл бұрын

This is frustrating! I keep getting an error when attempting the first method (Expression.Error: We cannot apply field access to the type Function.) But creating a custom function works. What could be the issue?

@MyOnlineTrainingHub 3 жыл бұрын

Not sure what you're trying to do exactly, Chris. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@9029710280 3 жыл бұрын

Hello mam if i dont have date in raw data and i want to add current or yesterday date how we can do this in power query

@MyOnlineTrainingHub 3 жыл бұрын

You can use the DateTime.LocalNow function to get today's date. e.g. =Date.From(DateTime.LocalNow())

@9029710280 3 жыл бұрын

@@MyOnlineTrainingHub Okay Thank you i will try the same

@cherifdiallo3813 2 жыл бұрын

I'm using Power Query and I looking to find Future Value function Does anyone knows where I can find it please

@MyOnlineTrainingHub 2 жыл бұрын

There's no built in function for this. You'd have to write it as a formula where you substitute the values into it: FV=PV(1+r)^{n}

@senthilramana 2 жыл бұрын

When you type the = # you should have zoomed to max. Still I couldn’t read what you typed while viewing in my phone. Need to see this video on my laptop to see what you have typed.

@MyOnlineTrainingHub 2 жыл бұрын

Yes, sorry about that. I guess we don't expect people to be viewing on their phone something they can only use on a PC.