There are lots of add-ins and incomprehensible explanations out there of how to do this. This was straightforward, easy to understand and worked right away. Many thanks!
it didn't work for me AND IT DROVE ME NUTS! but i figured it out for people using mac. just enter the ofrmula as it is flash-fill then select all the column (with the median formula) then alt + shift + enter
how to make a median or percentile for multiple columns. column 1 = days, column 2 = month, column 3 = gender. is there a way to calculate median or percentile for multiple conditions
Hi, Chris, thank you for the great tutorial! I do have a question for you. I'm breaking down delivery time by customer and part type. I want to see the average delivery time by customer, then further broken down by part type, as well as total average across all customers and parts. I have this in my pivot table and I used your method for median. However, instead of giving me the median across everything, it gives me a different number and I'm not sure what the difference is. If I do it manually in the raw data sheet, I get 41, if I use the helper column as seen above, I get 87. Any advice? My sheet is very big and it's slowing the computer down significantly, making it harder for me to fiddle with.
This was a really helpful guide. They changed the behavior in Office 365 - for this particular example "Ctrl-Shift-Enter" isn't needed - it returns the correct result. This is part of their dynamic array formulas apparently. I am using both right now to maintain backwards compatibility with older versions of excel. support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
There are lots of add-ins and incomprehensible explanations out there of how to do this. This was straightforward, easy to understand and worked right away. Many thanks!
Frank, thank you so much for your comment.
This is a brilliant solution and very succinctly presented in an easy to understand manner. Thanks so much for posting
You're very welcome!
Thanks you
so simple yet I couldn’t see it till you showed it to me
You’re welcome 😊
This is perfect! Thank you so much. I can't believe I just found your channel today.
I'm glad you found my channel. Thank you, Serena.
Chris, this is amazing, I managed doing it with some big data
Thanks Darryl.
This is very easy to follow and straightforward - thanks!
Awesome workaround!!
Thanks, this is very useful! I apply the same concept for Mode
You are awesome, Chris!!
Great work around! Struggled with add ins until I found this
Here is another video I made using DAX to find the median. Thank you. ruclips.net/video/86ZzVhZqPO4/видео.html
Thanks!! This was super helpful.
You're welcome!
Thanks a fucking billion times Chris
Glad to help.
Great way to explain this. Congratulations and thank you!
Thank you for the feedback.
Thanks Chris 👍👍
Your are welcome.
nice shortcut. Thank you.
you're welcome.
So useful! Thank You!
Thank you for the positive feedback.
Amazing, life saver!
Great video. How would you add an additional column if you wanted to filter by two columns?
I'll have the video tomorrow. I just figured it out.
Thank you! Works great!
Thank you!
grande chris! Thanks!!!!
My pleasure!!
it didn't work for me AND IT DROVE ME NUTS! but i figured it out
for people using mac.
just enter the ofrmula as it is
flash-fill
then select all the column (with the median formula)
then alt + shift + enter
Great help thanks!
That is not using Median in a PitvotTable. If you have filters in the pivot table that doesn't work. That is simply create a median function
Thank you! :)
You're welcome!
Thanks, it worked!
Glad to help. Thank you for the feedback. I appreciate it.
how to make a median or percentile for multiple columns. column 1 = days, column 2 = month, column 3 = gender. is there a way to calculate median or percentile for multiple conditions
See if this other PT Median video works. I used a DAX formula. ruclips.net/video/86ZzVhZqPO4/видео.html
Nice example if you only have 2 columns. I have a pivot table with 10 columns and requiring matching on more than one cell.
But how do you do these functions on the pivot table itself?
Hi, Chris, thank you for the great tutorial! I do have a question for you. I'm breaking down delivery time by customer and part type. I want to see the average delivery time by customer, then further broken down by part type, as well as total average across all customers and parts. I have this in my pivot table and I used your method for median. However, instead of giving me the median across everything, it gives me a different number and I'm not sure what the difference is. If I do it manually in the raw data sheet, I get 41, if I use the helper column as seen above, I get 87. Any advice? My sheet is very big and it's slowing the computer down significantly, making it harder for me to fiddle with.
This was a really helpful guide. They changed the behavior in Office 365 - for this particular example "Ctrl-Shift-Enter" isn't needed - it returns the correct result. This is part of their dynamic array formulas apparently. I am using both right now to maintain backwards compatibility with older versions of excel. support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
You can use median in pivot table using a DAX formula. And your trick becomes useless ;))