THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Ranking with PowerPivot – a different approach

Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot.

If you know DAX or you read our book, you will find that a DAX expression can solve the issue. However, such a formula is more complex than necessary. The next version of PowerPivot might have more built-in DAX functions and should solve the ranking need with a simpler formula. In the meantime, it is interesting to know a different approach that relies on Excel skills instead of DAX ones. Alberto shows how to solve the issue without writing a single line of DAX. It is always useful to look for other ways to get the job done, and sometime this approach is more practical than trying to decode very complex formulas, especially in case you don’t have to refresh your data often!

If you want to touch the real Karma of PowerPivot, don’t miss the opportunity to follow one of the workshops I and Alberto are bringing all over Europe in the next few months.

You can find more info on Hope to see you there!

Published Wednesday, January 12, 2011 7:45 PM by Marco Russo (SQLBI)
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement