Reporting on products 'active' between certain dates

[Anonymous]

Hi all, 

On my report I have products with a start and end date, and I want to track throughout the year how many products were active in each month. Is it a case of establishing a seperate column/table of dates that are unconnected to the product start dates and then using this as a comparison to report back on how many are 'active' in any given month before they end? 

I've been playing with this for a while, and think I must be missing something obvious, therefore any help would be appreciated with regards to the logic I need to apply. 

Thanks! 

[mh2587 · Accepted solution]

Refering to thes articles

https://www.kasperonbi.com/powerpivot-use-case-getting-the-active-products-between-a-date-range-usin...

https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/

[Anonymous]

Used the approach listed on https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/ - perfect!

[Anonymous]

Two good links - thanks! 

I'll take a more detailed look and then come back with any additional queries, but they seem to make sense.