SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
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!
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
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.