Forum Discussion
Hires and Terminations Waterfall
Using MFelix’s sample data shouldn’t you get 4 for July 2017?
Try this Measure...
Employee Count = CALCULATE ( COUNT ( Table[Employee] ), FILTER ( Table, Table[Start Date] <= LASTDATE ( DateTable[Date] ) && ( Table[EndDate] >= FIRSTDATE ( DateTable[Date] ) || ISBLANK ( Table[EndDate] ) ) ) )
Using MFelix’s sample data shouldn’t you get 4 for July 2017?
Try this Measure...
Employee Count =
CALCULATE (
COUNT ( Table[Employee] ),
FILTER (
Table,
Table[Start Date] <= LASTDATE ( DateTable[Date] )
&& (
Table[EndDate] >= FIRSTDATE ( DateTable[Date] )
|| ISBLANK ( Table[EndDate] )
)
)
)
Sean Yes based on MFelix's data we would expect to get a value of 4 since two people were hired in 2016, one in June 17, and one in July 17. I'll try out your formula today and see if it gives the expected result. Thanks
I still fail to see how you can say it produces the expected results?
From July 2017 through January 2018 nobody is terminated !
So you should stay at 4 yet your chart above dips to 3 for the Months - Aug, Sep, Oct, Nov
Your chart also has no entry at all for January 2018 - should be 4 still - no one hired or terminated
Then in February 2018 we add 1 - so we should be at 5 yet your chart show 2
and so on...
- Hi ,
You are correct I will remove my second answer so others cannot be mislead on reading the thread .
If your answer isn't marked as correct in the next days I will do it since it's correct.
Regards,
MFelix
Hi Schneider879,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
