Active day count in DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Alberto Ferrari posted a very nice blog entry some time ago regarding how to count active days in PowerPivot ( ). His example relies on a data model that specifies 'Active From' and 'Active To' fields in order to compute the count.

I want to write a follow up entry for when such fields do not exist in the data model. If all you have is a start date reflected as a transaction recorded in your fact table, counting active days is still possible in DAX. Lets see how.


Tags: dax


2007-2015 VidasSoft Systems Inc.