Calculate Median in PivotTable

[@mappingtesting4267]

Thank you. Great tip. Not found in many Excel experts channels. Thank you again. 👍

[@DougHExcel]

You're very welcome!

[@wayneedmondson1065]

Hi Doug.. great tip.. so many more options available when adding Pivot Table data to the Data Model. Thanks for all the tips and insights.. learning a lot from your channel and videos. Thumbs up!!

[@DougHExcel]

Glad it was helpful!

[@saraslaoui3320]

Thanks for the Tip, very clear and simple

[@DougHExcel]

Thanks for commenting!

[@excelisfun]

DAX is so much fun!!!!!!

[@DougHExcel]

It's pretty powerful! Thanks Mike

[@r4rajiv1979]

Thank you, very helpful...

[@DougHExcel]

Glad it was helpful!

[@eleanortay7351]

Great thanks for sharing this amazing feature for pivot table which I just discovered through this post. 😀👍

[@DougHExcel]

Hi Eleanor Tay, you're welcome!

[@the_kusk3356]

SOOO helpfull, I have been looking for this, in the last many years!

[@DougHExcel]

Glad it was helpful!

[@irving2006drummer]

Thanks for the video! It was really helpful!

[@DougHExcel]

You’re welcome, glad it helped!

[@kurtscheffrahn7834]

Thanks for the help! When there are new rows, how can you update the values of the range? Updating the pivot table with new rows breaks it, and it needs to be restarted again.

[@filiphuwaert724]

Thank you! Well explained.

[@DougHExcel]

Glad you enjoyed it!

[@joacimolsson1973]

Thank you!

[@DougHExcel]

You're welcome!

[@gregprovin5866]

Thank you! Very helpful tip

[@DougHExcel]

Glad it was helpful!

[@x2h3]

Great tutorial! Solved my problem!

[@DougHExcel]

Glad it helped!

[@pmsocho]

Thanks for the video!

[@DougHExcel]

Hi pmsocho, thanks for the comment!

[@juanlara6725]

What a great tip. Thank you so much

[@DougHExcel]

You’re welcome!

[@staffanbergstrom2265]

Great Help!! Thanks!!

[@DougHExcel]

Glad it helped!

[@jaymzfagan]

Great stuff, thank you. Do you know how to make the median measure ignore zeros in the variable range?

[@DougHExcel]

Hi jaymzfagan, thanks for the comment! One option is to create a helper column of TRUE/FALSE to flag the value of zero and then use it as page filter.

[@parasghai5994]

just what I was looking for

[@DougHExcel]

Thanks paras ghai, glad it helped!

[@dhunpagla3871]

Super information ..Thanks D

[@DougHExcel]

Always welcome

[@yf9anoopvi]

Thankyou very much

[@DougHExcel]

You’re welcome!

[@tutsecret499]

If I am in a test, which calculator do I use to get the mean, median and mode. I am looking my manual calculator SHARP, I don't see any special keys. I checked the calculator in the computer, but I don't know which symbol to look for?

[@cagivasupercity]

tnx very good help

[@DougHExcel]

Thanks @cagivasupercity, glad it helped!

[@melissaalleyne5835]

omg thank you!

[@DougHExcel]

Welcome!

[@7absinth]

Cool till you encounter to the next problem, that grouping for example by ages is disabled in pivottable when you add this table to data model.

[@ustadmas]

good content.

[@DougHExcel]

Hi Ustad MAS, thanks for the comment!