Forum Discussion

Vishal7012's avatar
Vishal7012
Regular Visitor
3 years ago
Solved

Resignation count

Hi,   I'm trying to get the count of employees who are serving notice period as of today from the database. Primarily, if the last working date of an employee is beyond today, it should count as th...
  • Anonymous's avatar
    Anonymous
    3 years ago

    oh my bad 

    Count =
    VAR _table = SUMMARIZE(FILTER('Table','Table'[Last Working date] <>BLANK()),'Table'[Employee Id],"Terminated",[Terminated])
    Return
    COUNTROWS(FILTER(_table,[Terminated] = "Yes"))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

oh my bad 

Count =
VAR _table = SUMMARIZE(FILTER('Table','Table'[Last Working date] <>BLANK()),'Table'[Employee Id],"Terminated",[Terminated])
Return
COUNTROWS(FILTER(_table,[Terminated] = "Yes"))
Vishal7012's avatar
Vishal7012
Regular Visitor
3 years ago

thanks, this works!