Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Inspired by all the great blog posts on doing a Dynamic Top X reports on PowerPivotPro I decided to try solving it using Excel 2013. As you might have heard Excel 2013 Preview has been released this week, check this blog post to read more about it.

The trick that I am going to use is based on my other blog post that I created earlier: Implementing histograms in Excel 2013 using DAX query tables and PowerPivot. The beginning is the same so I reuse parts of that blog post in this blog.

Read more...

Tags: dax, excel, tabular

 

2007-2015 VidasSoft Systems Inc.