Forum Discussion

vengadesh_p's avatar
vengadesh_p
Icon for Helper II rankHelper II
4 years ago
Solved

How to Calculate Active Employees based on Rolling Status

Hi All, I have data like below Table   I want to calculate no of Employee who are "in" Status Expected OutPut  A & B was "IN Status" from Mar/2021 and "Out Status from Jun/2021 So for A...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    vengadesh_p , Create a date table and join on date with this table. Use date from date table in this visual

     

    Try measures like

     

    emp = count(Table[Employee])

     

    Cumm Hire = CALCULATE([emp], FILTER(ALL('Date') , 'Date'[Date] <= max('Date'[Date])), [Status] ="IN")
    Cumm Termination = CALCULATE([emp], FILTER(ALL('Date'), 'Date'[Date] <= Max('Date'[Date])), [Status] = "OUT")
    Current Employee = [Cumm Hire] -[Cumm Termination]

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

vengadesh_p , Create a date table and join on date with this table. Use date from date table in this visual

 

Try measures like

 

emp = count(Table[Employee])

 

Cumm Hire = CALCULATE([emp], FILTER(ALL('Date') , 'Date'[Date] <= max('Date'[Date])), [Status] ="IN")
Cumm Termination = CALCULATE([emp], FILTER(ALL('Date'), 'Date'[Date] <= Max('Date'[Date])), [Status] = "OUT")
Current Employee = [Cumm Hire] -[Cumm Termination]