Forum Discussion

rdonohoe's avatar
rdonohoe
Regular Visitor
8 years ago
Solved

Active Employees

Hi,   I have a table employees with two relevant fields start and end.    I have a line chart showing the numbers of new and leaving employees per month over a year. I am looking to add a thind l...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    rdonohoe,

     

    You may refer to the following measure.

    Measure =
VAR d =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Table1[employeeId] ),
        FILTER ( Table1, Table1[start] = d )
    )
        + 0
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

rdonohoe,

 

You may refer to the following measure.

Measure =
VAR d =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Table1[employeeId] ),
        FILTER ( Table1, Table1[start] = d )
    )
        + 0