Power Query Advanced Editor - Pro Tips Made Easy - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
doug
I received a spreadsheet with a power query but it only looked up one year and one corporate division. The provider received the spreadsheet from our IT department and I would have to wait for him to submit a revision request. Dude, just edit the code. Opened the advanced editor found what I needed to change, and the query now works for my needs. IT was like in shock that someone not from IT could do this. Who needs MIT or Cal Tech when I have Mynda.
reply
I received a spreadsheet with a power query but it only looked up one year and one corporate division. The provider received the spreadsheet from our IT department and I would have to wait for him to submit a revision request. Dude, just edit the code. Opened the advanced editor found what I needed to change, and the query now works for my needs. IT was like in shock that someone not from IT could do this. Who needs MIT or Cal Tech when I have Mynda.
reply
Kaden
When you create the -Total- Variable and then divide each line by that total.. how do I create a total for a specific category? For instance if I have Group A with several items in Group B underneath group A, how do I total all of B and reflect that total for Group A? And then reflect each item in Group B as a percentage of Group A? Will provide data if anyone is able to help.
reply
When you create the -Total- Variable and then divide each line by that total.. how do I create a total for a specific category? For instance if I have Group A with several items in Group B underneath group A, how do I total all of B and reflect that total for Group A? And then reflect each item in Group B as a percentage of Group A? Will provide data if anyone is able to help.
reply
Paolo
Hi Mynda. Thank you very much for your videos. They are extremely helpful. I wonder if you could help with a problem. I am not able to connect an excel worksheet to an Access dB protected with password. I have tried different ways to no avail. Can you make a video about it? I looked for solutions over the internet finding none. Thanks in advance.
reply
Hi Mynda. Thank you very much for your videos. They are extremely helpful. I wonder if you could help with a problem. I am not able to connect an excel worksheet to an Access dB protected with password. I have tried different ways to no avail. Can you make a video about it? I looked for solutions over the internet finding none. Thanks in advance.
reply
Chukwuma
Love it!!. Interesting thing about adding a list in advanced editor. This means it might be possible to refer to an external dataset as a list or even a dynamic web page (possibilities seem endless)
reply
Love it!!. Interesting thing about adding a list in advanced editor. This means it might be possible to refer to an external dataset as a list or even a dynamic web page (possibilities seem endless)
reply
Raynald
Wow this is the best Advance editor Video i have found yet
Thank you very much first to you Mynda for this exceptional Chanel
and also to Phillip for these very clear tips
reply
Wow this is the best Advance editor Video i have found yet
Thank you very much first to you Mynda for this exceptional Chanel
and also to Phillip for these very clear tips
reply
Bj-rn
Thanks for the superb tutorial. Is it feasible to use power query to do some of the basic calculations rather than relying on DAX? Which is more processing power efficient?
reply
Thanks for the superb tutorial. Is it feasible to use power query to do some of the basic calculations rather than relying on DAX? Which is more processing power efficient?
reply
Nadeem
I have used advance editor sometimes, but never knew that we can create steps in between that can be called in custom columns or later in the code. Well done, great work.
reply
I have used advance editor sometimes, but never knew that we can create steps in between that can be called in custom columns or later in the code. Well done, great work.
reply
Aik
Great tutorial on the M syntax. The key features of assigning variables and writing simple functions is very handy. Thank you for creating this video.
reply
Great tutorial on the M syntax. The key features of assigning variables and writing simple functions is very handy. Thank you for creating this video.
reply
Grainne
Very clear and I formative. Thanks Phil! I hope you are going to offer an advanced MCode course on MOTH. Sign me up now!
reply
Very clear and I formative. Thanks Phil! I hope you are going to offer an advanced MCode course on MOTH. Sign me up now!
reply
Add a review, comment
Other channel videos
