Forum Discussion
Solved
Active Employees per Period
Hi, struggling with what should be simple. I have two tables ('crm_employees' and 'DimDates'). There exists a relationship between them (see picture below). What I am trying to calculate i...
Thank you for the advice. I tried it and do not get the correct result, either. What I do get is the number of employees, who left in a specific period (e.g. month).
As I have to deliver the report today, I resolved to take a different approach, showing the number of joiners, leavers and overall evolution of active personnel as in the chart below.
rl_evans I assume the filtering not working is due to the fact that if I'm selecting a particular month, and the relationship between [Approved Date] and [Date] is active, then I'm just filtering the data for all [Approved Dates] in that month. The filter doesn't take into account the measure at all.
rl_evans I've done a bit of testing and this does seem to be the case