| Writing a RANK measure (and living to tell the tale) |
| Written by Rob Collie |
| Wednesday, 10 March 2010 00:41 |
|
Before I get started, do you have any idea how hard it is to find cartoon images from the pre-Internet era? I just lost ninety minutes, first looking for the Far Side cartoon of “Custer’s Last Group Photo” (where everyone is holding up the “we’re number 1!” finger – get it?) and then struggling to find a version of the Beavis and Butthead image above at a better size. No dice. OK, enough of that… DAX v1 has no RANK() functionThat’s right. If you want to write a pivot measure that tells you where a particular store, or product, or customer ranks according to another measure, and according to current filter context, well, a RANK() function would be nice. But there wasn’t time to implement it in PowerPivot v1. Rank continued – dealing with unknown members...
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
