Resignation count

[Vishal7012]

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 the employee serving notice.

For eg. from the below table, count of employees serving notice period should be 3 (10003,10004,10005) as the last working date is beyond today.

Employee ID	Last working date
10001	12-Dec-22
10002	1-Jan-23
10003	31-Jan-23
10004	1-Feb-23
10005	21-Feb-23
10006	1-Nov-22

[eliasayy]

For visual purpose.

Simply add a new measure 

Today's date = TODAY()

now add thisbto yoir visual,

Create another measure 

Terminated = if(max(table[last working day]) < [Today's Date], "yes","no")

Now create a count measure

Count measure = 

Var summary = summarize(table,[employee id],"terminated column",[Termintaed]

Return

Calculate(distinctcount([terminated column]),terminated = ""yes")

[Vishal7012]

Thanks. There is a syntax error i'm getting while i use the count DAX wherein i'm unable to get the "terminated". Just doesnt seem to identify

Calculate(distinctcount([terminated column]),terminated = "yes") 

[eliasayy · Accepted solution]

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]

thanks, this works!