Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
8 years ago
Solved

Calculating monthly employees

 Hi,   I would like to calculate the monthly active employees.   I have a colom with a startdate, I have a colom with an enddate (if they became inactive) and I need to use employee numbers under...
  • Wiene24's avatar
    Wiene24
    8 years ago

    It was eventualy fixed with the following formula:

     

    Aantal actieve medewerkers per maand =
    VAR currentDate =
        MAX ( Datumtabel[Date] )
    RETURN
        CALCULATE (
            COUNTROWS ( 'dba Medewerker' );
            FILTER (
                'dba Medewerker';
                ( 'dba Medewerker'[DatumInDienst] <= currentDate
                    && 'dba Medewerker'[Datumuitdienstnieuw] >= currentDate )))

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
8 years ago

I fixed the error what I got when I tried to use it in a diagram, but the final result now is that I see how many people joined the company in what year/month.

 

So still don't have the active people on a monthly base.

 

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
8 years ago

It was eventualy fixed with the following formula:

 

Aantal actieve medewerkers per maand =
VAR currentDate =
    MAX ( Datumtabel[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'dba Medewerker' );
        FILTER (
            'dba Medewerker';
            ( 'dba Medewerker'[DatumInDienst] <= currentDate
                && 'dba Medewerker'[Datumuitdienstnieuw] >= currentDate )))