Working days computation in PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

A very frequent question, when performing business analysis, is to count the number of working days in a certain period of time. Creating a data model with PowerPivot that gracefully handles working days is pretty easy, nevertheless it is worth a post.

As you might already know, PowerPivot needs a calendar table to compute most of its time intelligence functions and this table needs to satisfy some important conditions:

Read more...

 

Tags: dax, excel, date, design

 

2007-2015 VidasSoft Systems Inc.