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.
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.
![Megan Thee Stallion - Bigger In Texas [Official Video]](http://i.ytimg.com/vi/QxTkZTLWdo4/mqdefault.jpg)
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!
Glad it helped!
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. :)
You're welcome!
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 for the feedback!
Thanks for this insightful video! Was able to use it in my dashboard
Great to hear!
Thanks Doug! You saved me so much time.
Glad it helped!
Nice one Doug! Thanks for sharing how to design this solution. Thumbs up!!
Thanks Wayne!
great job!
Thank you! Cheers!
Big help thanks
Glad it helped!
worked as a charm for my needs!
Thanks Jasmina Dimitrova, glad it helped!
Thank you Doug. Nice and informative video 📹
Glad you enjoyed it!
Thanks a lot!
You're welcome!
Спасибо большое! Вы мне очень помогли)
Пожалуйста. Рад, что это помогло!
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 Jerry Dellasala, thanks for the comment! Maybe another video in the future!
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??