Hi Brandon,
Maybe this will be of help? http://sqlblog.com/blogs/alberto_fer...owerpivot.aspx
Has anybody created an DAX measure to return the top 10 items. For example I am looking to return the top 10 items by sales dollars.
I know this can be done in a pivot table but I need to have multiple days of information and the pivot table will be to large, making using the file inefficient.
Hi Brandon,
Maybe this will be of help? http://sqlblog.com/blogs/alberto_fer...owerpivot.aspx
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Check out the TOPN function.
technet.microsoft.com/en-us/library/gg492198(v=sql.110).aspx
Bookmarks