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
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
---------------------------------------------------------------------
To download the excel files:
---------------------------------------------------------------------
To subscribe:
---------------------------------------------------------------------
To follow on Facebook:
---------------------------------------------------------------------
To follow on linkedIn:

[CAKPRashique]

It’s clearly understood. U done ur job best

[StefanoVerugi]

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

[krismansalindeho]

Amazing. God Bless you and your family

[jennale]

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

[MrFredy]

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

[Himanshu]

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!

[altafhussainbakhwani]

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

[zahoorsarbandi]

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

[simonoganga]

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

[ozGold]

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

[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 ❤❤

[minadev]

"Avg Revenue Per Trax(X):=AVERAGEX(SalesT, [Total Revenue(X)])". When we put on this formula, how come DAX knew we wanted to find the average by the number of transactions, not the total of Quantity?

[minadev]

Can someone clear my doubts please? The total average revenue should be $6, 568.00 as per every Average revenue per trax in Pivot Table

[chandramohan]

Please remaining videos once every week.thank yu.

[lorenzoladejobi]

Excellent video ! . Thank you for this.

[Aruntauru]

Hi, need help where financial year start from 1st April.

[kimsanov]

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

[tahaashour]

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

[AhmedAlaa]

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

[kimsanov]

One more question, sir. I used this formula Total Revenue and it works even without RELATED. Is there any issues with my approach?