How to Uncover the Hidden Power Query Function List! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Filip
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.
reply
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.
reply
Salina
I key in =#shared, I get an error saying Formula.Firewall:Query -Query 1'(step -Source') is accessing data sources that have privacy levels which can't be used together. please rebuild this data combination. I tried -=#shared- and that didn't work either. Am I missing some setting? Help! Thanks.
reply
I key in =#shared, I get an error saying Formula.Firewall:Query -Query 1'(step -Source') is accessing data sources that have privacy levels which can't be used together. please rebuild this data combination. I tried -=#shared- and that didn't work either. Am I missing some setting? Help! Thanks.
reply
Davide
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
reply
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
reply
Wayne
Hi Mynda. A great tip! When I first learned this, it saved so much time vs. always running out to Google. Didn't realize some of the capabilities you demonstrated. Thanks for sharing and always adding something to my knowledgebase :)) Thumbs up!!
reply
Hi Mynda. A great tip! When I first learned this, it saved so much time vs. always running out to Google. Didn't realize some of the capabilities you demonstrated. Thanks for sharing and always adding something to my knowledgebase :)) Thumbs up!!
reply
Chris
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?
reply
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?
reply
Iv-n
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.
reply
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.
reply
Simon
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.
reply
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.
reply
Imran
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.
reply
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.
reply
Senthil
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.
reply
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.
reply
Innovatell
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??
reply
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??
reply
Add a review, comment
Other channel videos
