Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Employee Turnover help

Hello all,   I am working on what I think is a simple dashboard, but has proven to be not the case. Or maybe I'm making it complicated. I'm trying to produce a dashboard for Employee Turnover. I ha...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago

Anonymous

Supposing that the x-axis is the date column from a calendar table, to get running total of active employees, you can try to create a measure as

 

running_total_of_active_employees =
COUNTROWS (
    FILTER (
        ALLSELECTED ( yourTable ),
        yourTable[hiredate] <= EOMONTH ( MAX ( CALENDAR[DATE] ), 0 )
            && (
                yourTable[FireDate]  > EOMONTH ( MAX ( CALENDAR[DATE] ), 0 )
                    || ISBLANK ( ( yourTable[FireDate] ) )
            )
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Just to make sure I get this correct, the relationship to my Date table needs to be on the hire date?