| PowerPivot: Counting active days |
| Written by Alberto Ferrari |
| Thursday, 12 May 2011 22:08 |
|
Browsing on the web I have seen an interesting question that is worth a post, since I think it is a very common pattern and a good example of "thinking in DAX". Starting from a table which contains a people and two dates (ActiveFrom, ActiveTo), we want to compute how many days an individual has been active over some period of time, let us say at the month level. Read more... |
Author articles
- Clever Hierarchy Handling in DAX
- Understanding Circular Dependencies in Tabular and PowerPivot
- Video - Many-to-Many Relationships in DAX
- KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
- Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall
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?
