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 www.powerpivotworkshop.com. Hope to see you there!