Forum Discussion

Schneider879's avatar
Schneider879
Frequent Visitor
7 years ago
Solved

Hires and Terminations Waterfall

Hello,   I'm hoping you all have some suggestions for how I could accomplish creating a creating a chart that will essentially count a hire as a +1 and a termination as a -1, giving me the net head...
  • Sean's avatar
    Sean
    7 years ago

    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's avatar
Sean
Icon for Community Champion rankCommunity Champion
7 years ago

 

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...

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago
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