APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets

[@BharathiM-t8y]

wonderful.. teaching

[@vacilando86]

One of the best M code explanations with great sample.Thank you

[@AAAExcel]

Thank you so much, happy that you like it

[@kuyakambo2327]

Your Channel is a hidden gem, you deserve a millions of subscribers. Your tutorial on M Code is so amazing. The way you teach is easy to follow with. You made everything looks so simple.

[@AAAExcel]

thank you for nice words, i want to let you know that i post in this channel video in both languages, English and Arabic, starting May i will post English videos to a new channel dedicated for English content only. please subscribe and encourage others to receive notification regarding latest videos youtube.com/@aaaexcelenglish

[@YOMOODY]

@@AAAExcel I 100% agree on this !

[@AAAExcel]

Thank you 🙏

[@StefanoVerugi]

beautiful video, learned so much in less than 30 mins thanks

[@AAAExcel]

My pleasure.. thank you for your comment

[@vijayarjunwadkar]

Wow, What a Video! Excellent Tutorial! I got clear on so many things about Table Functions and M in just this one! Thanks a lot, I am going to check all your other videos soon! Keep up the great work! 😊👍

[@AAAExcel]

Happy that you find it useful, thank you for the nice words 😊😊

[@PaúlAlexanderRivasLaBarrera]

Tus tutoriales son de mucha calidad, gracias por compartir tus conocimientos.

[@AAAExcel]

Eres muy bienvenido

[@10ozGold]

Excellent video. Well explained. And going at a good pace. Very good using Table functions all within one step. Also, good M code formatting to be same way as DAX.

[@AAAExcel]

Thank you so much, happy that you like it 😊

[@kennethpaige7036]

That was very, very good. The contrast between your explanations and others I have watch is just striking. You have a true talent for teaching. Thank you so much!

[@AAAExcel]

Thank you for your kind words, appreciate it 😊😊

[@GosCee]

Excellent teaching! Thank you very much.

[@AAAExcel]

Most welcome 🙏

[@aniljaggarwal60]

Wonderful, Thanks for explaining difficult/complex coding programming in very simply manners

[@AAAExcel]

Thank you so much, happy that you like it 👍

[@jbgolf26]

Truly amazing video and explanations. Thanks for your work!

[@AAAExcel]

Thank you 🙏

[@FsoOmar]

رائع جدا، أسلوبا وعرضا ومعلومات. استفدت كثيرا منك، وأعجبني تنظيمك في كتابة الكود مرتبا وموزونا. إذا كان أحمد شوقي أمير الشعراء، فحضرتك أمير الباور كويري، بجد والله. جزاك الله خيرا ووالديك،

[@AAAExcel]

اشكرك شكرا جزيلا على كلامك الجميل وكل عام وانت بخير وعيد مبارك ان شاء الله

[@FsoOmar]

@@AAAExcel كل عام وأنتم بخير. الشكر لك لتطوعك بالتدريس الراقي مجانا. ⚘

[@muhammadshahzadafzal6229]

Excellent again . Sir, you are simply the best!

[@AAAExcel]

Thank you so much 😊

[@kishorpanara4191]

Dear i am waiting for your video and thank you for video in English

[@AAAExcel]

Most welcome 🙏

[@alexrosen8762]

Amazing tutorial. Great pace and easy to understand language

[@AAAExcel]

Thank you so much for your comment 🤗

[@israfilgazi8071]

How well explained to make anyone understand was Really Unbelievable to me before watching this video. ❤❤❤

[@AAAExcel]

Thank you so much, happy that you like it 😊

[@zahoorsarbandi2982]

Wonderful!...exactly what I was searching for... Thank you sir...

[@AAAExcel]

Happy that you like it 👍👍

[@zahoorsarbandi2982]

@@AAAExcel believe me we are waiting for your videos. Kindly release more and more videos on Power Query... I know you have videos in Arabic but we don't understand Arabic.. from Pakistan.

[@AAAExcel]

Thank you so much Zahoor for waiting me, Arabic is my mother tongue, that’s why I am doing Arabic ones, but believe me I adore all friends from Pakistan and the rest of the world as well, I will do my best to post frequently in English. And appreciate your support by sharing my work with your colleagues there in Pakistan - thank you 🙏

[@jawadahmadehssan6251]

Well explained. Thank you.

[@AAAExcel]

Thank you Jawad 🙏

[@SamehRSameh]

Magic video as usual 🥰 Please minimize space in code to see all code

[@AAAExcel]

Thank you so much ya Sameh, will consider ISA

[@MrFredy65]

Excellent video.....Thanks a lot from Colombia.....I hope the next!!!!....

[@AAAExcel]

Welcome to all Columbian mates, happy that you like it 😊

[@MrFredy65]

@@AAAExcel Your videos are very interesting to me....When obtain more.....

[@AAAExcel]

Soon my friend, happy that you like them

[@MrFredy65]

@@AAAExcel Ok...Thanks....

[@quadcoresprashant]

Nice video a lot to learn in most cleaner way

[@AAAExcel]

Thank you so much for your comment 🙏

[@SantiagoMolero]

Thank you!!

[@AAAExcel]

Most welcome 🙏

[@agostinhosubtil569]

Amaizing. Thank.

[@AAAExcel]

You’re welcome.. thank you 🙏

[@Hurmali1]

I get this type of raw data quite often, I like the way you get the steps much shorter

[@barakAllah468]

Excellent video ❤️

[@AAAExcel]

Thank you 🙏

[@mnowako]

What an amazing video! 👏

[@AAAExcel]

Thank you so much 😊

[@SaleemShouket-r3p]

Great job done

[@AAAExcel]

Thank you 🙏

[@SaleemShouket-r3p]

@@AAAExcel I have been watching different videos on MS Query from 8 Months almost, But you are BEST, you explain very well, which is understandable for many mores. it is a voluntary charity which remain forever... May ALLAH bless you always.

[@kennethstephani692]

Very very good video!,

[@AAAExcel]

Thank you very much!

[@KhajonsakLun]

Thank you very much for great video, I love it.

[@AAAExcel]

Happy that you like it.. thank you 😊

[@michafabich9213]

this is really insightful. thnaks for that

[@AAAExcel]

Most welcome 🙏

[@Altaf_Alam]

Your videos really help me a lot to understand the concepts... Thank u very much sir 😍 The way you teach is just tremendous 😊

[@AAAExcel]

Glad to hear that, thank ou so much

[@itgyantricks7218]

Excellent

[@AAAExcel]

Thank you 🙏

[@ajieapen]

Cool tips... Could you also explain how to dynamically choose the number of rows to be skipped, please?

[@AAAExcel]

This will be exactly my next one .. stay tuned

[@ajieapen]

@@AAAExcel Thank you... :)

[@mahamohan1]

Fantastic.

[@AAAExcel]

Thank you

[@aldredjansen9638]

Well presented. Kindly supply with more info when joining as a serious learner. What does the course detail entail?

[@AAAExcel]

Sorry for the late echo, there are some additional content but all in Arabic language

[@cheikhhakim5864]

lot of thanks sir

[@AAAExcel]

My pleasure dear

[@HaiderAli-vt8wn]

I become a fan of you, thanks

[@AAAExcel]

My pleasure dear 😊😊

[@muhammadshahzadafzal6229]

Sir..Desperately waiting for APQ04 :)

[@AAAExcel]

Working on it dear

[@engahmedelbendary1566]

thx you for your effort and i hope to continue in Table Functions with how to skip different numbers of row in more than 1 table ,and how to delet Empty Columns Dynamic &how to e Column Name in dynamic

[@AAAExcel]

Hi Ahmed, skipping different number of rows will be the next, then some tricks about the columns. Thank you for your comment 😊

[@SaleemShouket-r3p]

You are the Best

[@cheikhhakim5864]

please sir how can we treat the same example with the technique of functions , as we see in the last video APQ01

[@AAAExcel]

Hey, so simple, you can just convert the code to a custom function and invoke when needed

[@cheikhhakim5864]

in this example you worked with the table function on the workbook itself (the entire wokbook) , in cas cas we work on a single sheet ( jan 2021 or feb 2021...) how can we get the the name from a cell . thank you sir in advance

[@phoolkhan87]

Hi, Very informative video. Just want to know one thing, How can we apply same step when we choose the get data from folder 📁 option?

[@AAAExcel]

Hi Sorry for the very late response, Actually you need to start by working on one sample query, once you finish all required transformations, you got to convert the sample query to a custom function. Next, get the data from the folder and apply the custom function to all data files in a new column, finally remove other columns and expand all tables, you will get all files transformed and combined in one table

[@HaiderAli-vt8wn]

Hi, is it possible we add a parameter that change the date value in SAP Hana SQL Query. I have a query contain start date & end date using paramete I can change strat date & end Date? Thanks

[@AAAExcel]

I guess you can

[@patrickharilantoraherinjat2994]

Hi we can easily use UI and PowerQuery will generate the code

[@AAAExcel]

I don’t know what is UI

[@patrickharilantoraherinjat2994]

@@AAAExcel I mean User Interface in PowerQuery

[@AAAExcel]

Hmm, thank you for clarification, you’re right, but in some cases you need to right some functions

[@patrickharilantoraherinjat2994]

@@AAAExcel I agree with u

[@manjeetmarothiya1519]

Dear Sir.. Please make more video on Power Pivot.. Please make a video on how to merge Multiple table where column are not in same order.. with thehelp of List..Imp interview question asked .

[@AAAExcel]

Hello dear, will consider in the coming period

[@faroukbassyouny3743]

Nice effort really but why the video is not working in Arabic series

[@AAAExcel]

Thank you so much, it will be available next Saturday, I open it for Members only for one week

[@Marno_YouTube]

Please choice better transition sound because it breaks down on what you are trying to teach

[@AAAExcel]

I didn’t get your point? You mean you didn’t like the music ?

[@MaydayAggro]

I feel so stupid with my 20-odd step query that I just completed a day before watching this....

[@AAAExcel]

Always happen to me, at least you now know 2 ways to get your job done .. thank you 🙏

[@engahmedelbendary1566]

and i will prefer in Arabic

[@AAAExcel]

The Arabic version will be out in few minutes, I usually do both.

[@arturocdb]

Thank you!

[@AAAExcel]

You’re welcome