Excellent video, thanks a lot! You literally saved me after having spent several hours with this issue. Unlike what 99% of Google suggests, the solution is not to create a calculated field, but this!

Thank you for this video! Finally through my efforts with Google I found out it was possible in Power Pivot but this made it really easy to see how it works. :)

Doug Excellent job. Was able to put in my Dashboard. Your video can be much more crisper if you take away first 3 minutes of introduction. The point where you start using data and inserting table that's where a clean and crisp example begins.

Thanks Doug! You saved me so much time.

worked as a charm for my needs!

Thanks for this insightful video! Was able to use it in my dashboard

great job!

Nice one Doug! Thanks for sharing how to design this solution. Thumbs up!!

Thank you Doug. Nice and informative video 📹

Thanks a lot!

Big help thanks

Спасибо большое! Вы мне очень помогли)

Using the Data Model is a great trick, but would have liked to have also seen dynamic array formulas producing the same results without the need for a refresh, as well as a sample of the workbook.

Hi Doug, getting error after creating the measure as - mdxscript(model)(6,33) calculation error in measure 'range 1'[90th]: The percentile value should be in the range of 0..1, inclusive.

It won't let me summarize by avg. Can anyone help??