PP03: DAX Iterator Functions, Measures vs Added Columns, Filter Context, Internal & external filters

Chapters:
0:00 Intro
1:52 Filter Context
5:57 Measures vs Calculated Columns
12:26 DAX Iterator Functions (X Family)
18:23 AverageX function
27:08 Internal and External Functions
36:48 Closing
---------------------------------------------------------------------
To watch the full Playlist
• PP: Power Pivot Tutorial
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
---------------------------------------------------------------------
To download the excel files:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcel
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on linkedIn:
/ amratef

[@jennale7084]

You are the BEST! Love all your PQB series and now PPs! Thanks for all your hard work!

[@AAAExcel]

Thank you so much, happy that you are enjoying the content. Check out APQ as well, the link is below
th-cam.com/play/PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58.html

[@Himanshu0719]

Thank you so much for this series Sir!!
I've watched 3 lectures till now and feeling confident in DAX now, it's amazing.
You made it very simple.
Thanks a lot!

[@AAAExcel]

Most welcome .. happy that you found it useful

[@MrFredy65]

You are the best!!!....Great video, thanks a lot....I hope the next.............

[@AAAExcel]

Thank you so much, will do my best

[@krismansalindeho]

Amazing. God Bless you and your family

[@AAAExcel]

Thank you! You too!

[@zahoorsarbandi2982]

Superb presentation.. marks 100/100.. waiting for 4th video... hopefully this time we will see next video very very soon.

[@AAAExcel]

Thank you 🙏
Soon, stay tuned 😉

[@altafhussainbakhwani3847]

Outstanding presentation & thanks for giving wonderful knowledge. We hope to PPO4 video present very soon.

[@AAAExcel]

Thank you so much, soon

[@simonoganga8118]

Amazing content Sir, you make it so easy to understand which is so important

[@AAAExcel]

Thank you, happy that you like it 👍

[@StefanoVerugi]

Amazing video, you mister are putting competitors out of business, hands down! 🙂

[@AAAExcel]

Thank you Stefano

[@MUNANasher]

Thank you soooo much for you effort, I have benefited greatly from this tutorial it helps me a lot thank you thank you thank youuuu ❤❤

[@AAAExcel]

Great to hear! thank you for your comment :)

[@lorenzoladejobi8701]

Excellent video ! . Thank you for this.

[@AAAExcel]

Thank you 🙏

[@10ozGold]

Excellent video. Better explanations and pace than the smartest DAX guys Alberto and Marco.

[@AAAExcel]

Thank you so much dear 😊🤪

[@StefanoVerugi]

true, A&M are renown pros but they should wacth his videos to understand what matters the most to final users

[@AAAExcel]

Guys, you can’t compare me with those brilliant people, am not competing with them, just trying to share my humble knowledge.. am so grateful to your feedback.. thank you so much 😊

[@totomatic9124]

قناة مميزة. الله يعطيك العافيه.

[@AAAExcel]

شكرا جزيلا.. جزاك الله خير 🙏

[@chandramohan1418]

Please remaining videos once every week.thank yu.

[@AAAExcel]

Not that easy, long videos requires lot of preps with very limited spare time, bear with and will do my best .. thank you 🙏

[@kishorpanara4191]

Awesome i like it thank you dear

[@AAAExcel]

Most welcome 🙏

[@DrK99999]

Super. Keep going 😀

[@AAAExcel]

Thank you 🙏

[@cheikhhakim5864]

thank you sir

[@AAAExcel]

Most welcome

[@kimsanov]

What is the benefit of using fx Total Quantity vs sImply summing quantity in Pivot Table? I am talking about 4:13

[@AAAExcel]

Hi, sorry for the late reply, the benefit is to have an explicit measure instead of implicit one, this will allow you to give custom name and attach number format to the measure

[@tahaashour7061]

حضرتك انا اتعلمت اساسيات الاكسيل زي ماحضرتك رشحتلي نولوجي ابدا بانهي قائمه علشان ابدا تحليل البيانات؟

[@AAAExcel]

Pivot tables

[@kimsanov]

One more question, sir. I used this formula Total Revenue (My):=SUM(SalesT[Quantity])*SUM(Price_KG[Price]) and it works even without RELATED. Is there any issues with my approach?

[@AAAExcel]

You have use it as measure or calculated column?

[@kimsanov]

@@AAAExcel It was my mistake. My measure was just summing all prices from prices column)

[@AAAExcel]

All sorted now ?

[@kimsanov]

@@AAAExcel Yeah) Thanks for your tutorials)

[@AAAExcel]

My pleasure

[@MustafaDabaan]

الله يعطيك العافية استاذنا الفاضل
ياريت لو كان في ترجمة للعربي ؟؟

[@AAAExcel]

نفس الفيديو موجود بالعربي من اكثر من ٦ شهور .. معلش انا ليا متابعين عرب واجانب كمان ..
رابط الفيديو العربي: th-cam.com/video/ls3zTVUHM0w/w-d-xo.html

[@MustafaDabaan]

@@AAAExcel الله يعطيك العافية
بارك الله فيك وجزاك الله خير الجزاء

[@AAAExcel]

شكرا جدا 🙏

[@AhmedAlaa10114]

لو سمحت كل لما باجي اربط الاكسيل بالويب عني مابيرضاش وبيطلب باسورد ويوزر .. ومش عارف احلها ه ليها حصل

[@AAAExcel]

انت بتعرف تدخل نفس الويب سايت من غير يوزر وباسوورد ؟

[@abdullahibrahim5126]

هل الاشتراك في اليوتيوب مع حضرتك بيقبل كارت ميزة بتاع البنك الاهلي؟؟

[@AAAExcel]

والله مش متأكد.. الاشتراك عن طريق جوجل … اعتقد بيقبل

[@salemsalem597]

استاذنا نبي الشرح بالعربي طالما الشريحه اللي تابعك من العرب

[@AAAExcel]

نفس الفيديو موجود بالعربي من اكثر من ٦ شهور .. معلش انا ليا متابعين عرب واجانب كمان ..
رابط الفيديو العربي: th-cam.com/video/ls3zTVUHM0w/w-d-xo.html

[@salemsalem597]

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

[@AAAExcel]

شكرا جدا 🙏