| Determine the min value over rows in a group using MINX in PowerPivot |
| Written by Kasper de Jonge |
| Tuesday, 24 August 2010 21:59 |
|
I got a question that proved more challenging than I imagined. I have a report that displays the following values. It shows Days in stock per employee per Continent and per Country. The days in stock is a calculated measure: =DimGeography[DaysInStock per store] / DimGeography[NrOfEmployees in service] which again contains of two calculated measures. The question i got was if it was possible to show the minimal value of the measure [days in stock per employee] for each country grouped by Continent:
|
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)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
