Forum Discussion
Solved
How to create pivot table with median values?
Hi, I am seeking to make a pivot table that shows the different median values for different countries from a list of table. Could someone show me how to create pivot table with median values...
AmyYang See attached. Have used UNIQUE and FILTER to achieve what you asked for. See the green shaded area in the attached file.
- Hi Detlef, wow, a pivot table was really created with median values!! Thank you! I will search on how to use Power Query + DAX measure to recreate this for my other files too. Thank you so much!
