PP02: Power Pivot tutorial - Data extraction & modeling

[@shafeekahammed1549]

Simple but crystal clear...... you are the best teacher...... thank you so much............😍

[@AAAExcel]

Thank you so much 😊

[@walidshoeb8732]

زادك الله من علمه واستخدمك لما فيه الخير لك ولعباده

[@AAAExcel]

جزاك الله خير.. شكرا جدا 😊😊

[@JayBee-hb2pm]

Wow I’m addicted... well explained.. thank you

[@AAAExcel]

Happy that you like it, thank you so much

[@newidentity9299]

Great tutorials. Thank you!

[@WaqasKhan-sp3sn]

Love ur explaining way

[@nicolasinglesakis1161]

Very nice work. Nicely done

[@zahoorsarbandi2982]

very useful and really a nice explanation of all necessary aspects of importing data

[@AAAExcel]

Thank you 🙏

[@chandramohan1418]

Thank yu for much awaited PV Videos.PL upload remaining vidoes as soon as possible .thank yu.

[@AAAExcel]

Will do my best

[@MrFredy65]

Extraordinary....Thanks a lot....

[@AAAExcel]

Thank you 🙏

[@TheSandipstar]

Thank you sir.. Your Teaching skills is extraordinary.

[@AAAExcel]

Thanks and welcome

[@ferozkabir5184]

excellent video. thank you very much

[@DrK99999]

Atlast your 2nd video is here :) Super.

[@AAAExcel]

Thank you, will do my best to post the 3rd soon 😊😊

[@miguelmedina2867]

Assalamualaikum, thank you for sharing key and enlightening knowledge.

[@AAAExcel]

AlikumAssalam, my pleasure dear

[@entendedorww]

Top lesson. Mercy!

[@AAAExcel]

Most welcome 🙏

[@maksoudkakamal2356]

بارك الله فيك و في علمك و ربنا يجعله في ميزان حسناتك ان شاء الله يا دكتور عمرو انا عندي مشكلة مع related function دائما بتدي error مش عارف ليه

[@MM-oe2eo]

Thanks alot, very simplified.

[@AAAExcel]

Most welcome 🙏

[@kebincui]

Excellent; Thanks for sharing

[@AAAExcel]

Most welcome 🙏

[@minadev1]

Amazing content and teaching style. I have one question only when you count toal quantity (Ssum) and Transection (Count). I am not sure what you were trying to show there. Can you please explain.

[@oluwafemiorebe6290]

Perfect tutorial. Thanks

[@AAAExcel]

My pleasure 🙏

[@taham7629]

جزاك الله خيرا

[@AAAExcel]

وجزاك كل خير

[@nabilyounan594]

Very useful…. Thank you Amr

[@AAAExcel]

Thank you Bolbol, my dearest

[@SantiagoMolero]

Thank you!!!

[@AAAExcel]

Most welcome!!

[@fasasimosunmola1530]

This is one of the simplest breakdowns I have watched so far, thank you. But is there a way to access the files in order to practice please?

[@AAAExcel]

Thank you for your nice words, actually there is a link in the description box, you can use it to download the working files

[@rrpprp]

Brilliant, thanks!!!

[@AAAExcel]

My pleasure

[@kishorpanara4191]

Awesome and Thank you dear

[@AAAExcel]

Most welcome

[@sheyvitalismbunkur1949]

Thank you so much

[@AAAExcel]

You're most welcome

[@hieunhudinh6418]

many thanks bro

[@AAAExcel]

You're welcome!

[@minadev1]

Sum (Quantity) and then Count (Quantity). What is the difference?

[@reymantan3231]

HI Sir thank you for your videos. May I ask if you have power bi tutorials in english. Thank you and happy new year!

[@AAAExcel]

Hi, yes I do have an introductory video and some other, please check this out my first Power BI report | Introduction | Interactive Visuals | Slicers | Power Query | AI kzbin.info/www/bejne/kIKwYnabeamasJY

[@mmunozidata]

thank you

[@AAAExcel]

Welcome dear

[@jokhaalmahrouqi6613]

هل ممكن تستخدموا نفس الطرق من هذي السلسلة لشرح trial balance كمثال واستخراج المعلومات منها مثل cash flow land balance sheet اتوقع انه هذا تحدي جميل و واقعي

[@AAAExcel]

فكرة جيدة تحتاج الى وقت ومجهود كبير .. ان شاء الله نحطها في الخطة

[@trungucnguyen353]

Dear Mr, My Excel is 2016. But when I typed the formula into custom collum, the power query didn't propose formula syntax automatically like you do. Please to help :D

[@AAAExcel]

Excel 2016 is not supporting this feature

[@trungucnguyen353]

@@AAAExcel thank you.

[@ancycruz2029]

hi sir, can u help me with how to do ageing calculations in Dax eg-0-7 ,7-14,15-30,30-60,

[@AAAExcel]

Try switch function

[@ancycruz2029]

@@AAAExcel Hi sir could u make 1 video on switch function

[@tanveerabbas3271]

thk you.. would like to see u too❤

[@jamaludheen-f3t]

Hi good day. How to connect more than one ODC connection file in power pivot

[@AAAExcel]

Power Query is the best way to connect external data

[@ubaidillahmuhammad20]

it's pity. there is no file for practising