I would like to calculate headcount month over month based on hiredate.
Input Raw Data Hire Date Name Location 10/29/2019 A AAA 10/30/2019 B BBB 3/5/2012 C CCC 5/10/2018 E AAA 6/7/2018 F BBB 8/25/2017 G CCC 9/13/2016 H AAA 1/19/2020 I BBB 2/21/2020 I CCC 3/19/2020 I AAA 3/9/2020 I BBB Desired Output1 Number of Headcount per Month as on 2020 Headcount by month Jan'20 8 Feb'20 9 Mar'20 11Events 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. Thank you Norm
