Events in progress issue

[Anonymous]

Hi,

I used the solution here : http://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/

But I still have an issue with analysis by stage as at the end of the period. 

Formula I used is:

TableFIN = CALCULATE(

DISTINCTCOUNT(HistoriqueStatutsDossiers[Nb]),

HistoriqueStatutsDossiers[FileStatusName] <> "ENQ-Fermé",

GENERATE(

VALUES(Calendrier[Date]),

FILTER(

HistoriqueStatutsDossiers,

CONTAINS(

DATESBETWEEN(

Calendrier[Date],

HistoriqueStatutsDossiers[Status_Date],

HistoriqueStatutsDossiers[StatusEndDate]

),

[Date],Calendrier[Date]) ) ))

Visual total returning good number, but kept the previous event per former "StatusCode".  I expected to have only the latest StatusCode.

Thank you

Norm