Excel Median Mastery: Median in Pivot Table - Episode 2197

[@jer28002]

wow. it has been 6 years that I was so mad at Excel because we could not do the median in the pivot table. Thank you so much! it is almost a life changing video!!

[@amatya.rakshasa]

Wow. What an excellent video!! No time wasted at all. Every word uttered was well thought out and precise. hahaa I am way more happy about just the poetry of your presentation than learning about the median stuff.

[@excelisfun]

Totally awesome! I love DAX and I love your article that shows how we can hack any Excel 2016 or later version to get MEDIAN : )

[@sumitsachdeva5945]

Another great video by you, Sir Bill.

[@missulakartik6957]

This is next level. Loved it. Awesome.

[@AkaExcel]

Thank You! I was seeking for median in Pivots, now i found the DAX way!)

[@johndavis8415]

"How awesome is that"? Very. (Tip came in very handy - thanks).

[@soelver05]

Thanks for the tip. Very helpful!. Anyone know why excel does not allow median in pivot table as default?

[@almightydemons1]

Thank you for this, it was really helpful. Also, I've been trying to add "Mode" as a new measure but it's not allowing me to do so. Could you please explain, I'd really appreciate. Many thanks

[@finnurtg]

Excellent tip, Bill. Is that photo taken in Iceland? Have you been?

[@XLarium]

Power Query grouping also has a median function.

[@lkhaldane]

Very useful tutorial, thank you so much !!!

[@kuldeepsinghtanwar5842]

Hey.... I am a huge fan of yours 🙂 I have multiple tables with 2 columns named ENTERING and EXITING with multiple rows of start and end dates in it. What I want is to find out a common date range that falls in all tables. Can you please help ?

[@medicalphysicsbiomedicalen1707]

🎉 It was helpful ❤

[@kaushiksarkar]

Excellent

[@chevi893]

AWESOME!

[@simfinso858]

very useful

[@mohamedchakroun4973]

Thumbs up bill for this