APQ02: Advanced Power Query Video #2 - Parameters in PQ

[@BharathiM-t8y]

It is an amazing effort. no words to express my gratitude. one of the best trainer i have ever seen

[@zahoorsarbandi2982]

Mind-blowing video.. a complete package of Parameters.. Outstanding presentation... waiting for more videos

[@AAAExcel]

Thank you so much, happy that you like it

[@jerrydellasala7643]

Rather than hard coding the file path in the workbook, I would suggest the using Power Query to retrieve the files in the folder. I don't have it handy, but there is also a way to pull the list of files in the directory the data is in and filter by extension and name. I only mention it because you're posing good stuff, and love that you provide the files to follow along!

[@AAAExcel]

I am happy that you find my content useful, it's a great idea thank you for your contribution

[@felipesignorellireis7839]

your classes are simple and direct. Great. cheers from Brazil

[@AAAExcel]

Thank you so much, happy that you like them, cheers

[@Fxingenieria]

Espectacular !!!

[@AAAExcel]

Thank you :)

[@sedarathnadcd]

Thank you for sharing knowladge

[@AAAExcel]

My pleasure

[@khalidmajeed2886]

sir i love your explanation from very initial point to advance......jazakallah Allah will increase knowledge for those who divide which he has

[@AAAExcel]

It's my pleasure

[@jawadahmadehssan6251]

Very useful and practical examples. Thank you Amr.

[@AAAExcel]

Thank you Jawad, happy that you like them 🙏

[@hemarajani3400]

Awesome teaching. Thanks for sharing your knowledge

[@AAAExcel]

Most welcome 🙏

[@hichamhadj9640]

Brilliant, thank you brother

[@AAAExcel]

Very welcome

[@vacilando86]

Amazing tutorial. Thanks for your effort and sharing.

[@AAAExcel]

Most welcome 🙏

[@heddyjazy6252]

Hi, please i need to know how to export a folder with all excel files qnd transform with power query?

[@AAAExcel]

Hi, watch this video kzbin.info/www/bejne/Z6PWoYurqceCrLc

[@utubeAgape]

This is great - thank you!

[@AAAExcel]

You’re welcome

[@kapzforu5347]

Hi, I have a table from month Jan-21 to Dec-21. I need to dynamically calculate data on quarterly and yearly basis. How can it be done dynamically on power query?

[@AAAExcel]

Better to have done in power pivot using Dax functions, or you can just load it in pivot table and do all the calculations inside the pivot table

[@saromijuwon7151]

Can we do a validation if all the file path in the work sheet so we can have a drop down

[@AAAExcel]

Sure you can, it is a great idea

[@kishorpanara4191]

Excellent sir and thank you sir and you are great

[@AAAExcel]

Thank you for your comment 🙏🙏

[@kennethstephani692]

Great Video!!

[@AAAExcel]

Thanks for the visit

[@DariaLukashenkova]

Hi, Is there a way to change users in the link for the Source? not changing the whole path? (In case differen users want to update Excel file)

[@AAAExcel]

Hi, there is an option to limit access in power query, please check the below link support.microsoft.com/en-us/office/set-privacy-levels-power-query-cc3ede4d-359e-4b28-bc72-9bee7900b540

[@saromijuwon7151]

Is it possible to create alias for file path that are extremely long

[@saromijuwon7151]

E.g JAN_Opex AS JAN Just as SQL

[@AAAExcel]

Not sure, I am not an SQL expert

[@SaleemShouket-r3p]

very nice

[@alicemorili1330]

If I need a date in worksheet as parameters, how to use that to as filter inside power query?

[@AAAExcel]

Watch this, it may help kzbin.info/www/bejne/nIWznGWgbb-hiKc

[@ajieapen]

In the first example, if the multiplier has to be linked to the agent's experience, would that be possible too? 0.5 for 2 yrs experience

[@AAAExcel]

In such a case you may need to add a conditional column, parameter may be not relevant

[@ajieapen]

@@AAAExcel Ok.. Thank you...

[@SantiagoMolero]

Thank you!

[@AAAExcel]

You’re welcome

[@mohammed1981]

super as usual

[@AAAExcel]

Thank you

[@ravikumar-rw5rm]

Please sir make a video, How to data unfilter after change data

[@AAAExcel]

Hello dear, I didn’t get what this means?