Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Events in progress issue

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.
 

TableFinMeasureVisual.PNG

Thank you

Norm

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.