Forum Discussion

FruitBat's avatar
FruitBat
Frequent Visitor
6 years ago

Employee Start Date - Stop Date Ribbon Chart w/ Running Cumulative Total Employee Count

I'd like to create a Line & Clustered Column Chart having on the X-Axis a running list of dates representing the minimum or FIRSTDATE of all employee hires, up to the maximum or LASTDATE of all emplo...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi FruitBat ,

 

We can try to create following measure to get the change number of employee in the selected day.

 

 

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    FILTER ( ALLSELECTED ( 'Table' ), [FIRSTDATE] IN FILTERS ( 'Table 2'[Date] ) )
)
    - CALCULATE (
        DISTINCTCOUNT ( 'Table'[ID] ),
        FILTER ( ALLSELECTED ( 'Table' ), [LASTDATE] IN FILTERS ( 'Table 2'[Date] ) )
    )

 

 

 

 

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.


Best regards,

 

FruitBat's avatar
FruitBat
Frequent Visitor
6 years ago

Thank you, Don Li.  Unfortunately, that's not quite the result we're seeking, but it's close.

 

You're table below shows the correct schema - Employee ID, the employee's Arrive Date, and the employee's Depart Date.  Over a period of time, we expect arrivals to increase along the Y-axis cumulatively, and the departures to decrease along the Y-axis cumulatively, so that at TODAY() or any days along the X-axis, we'd see the present-day employee count.  Sorry if we hadn't made this clear at the outset.