topic Re: Resignation count in DAX Commands and Tips

Resignation count

Vishal7012 — Sat, 21 Jan 2023 14:41:27 GMT

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

Re: Resignation count

Anonymous — Sat, 21 Jan 2023 14:53:35 GMT

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")

Re: Resignation count

Vishal7012 — Sat, 21 Jan 2023 15:19:12 GMT

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")

Re: Resignation count

Anonymous — Sat, 21 Jan 2023 15:42:55 GMT

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"))

Re: Resignation count

Vishal7012 — Sat, 21 Jan 2023 15:45:19 GMT

thanks, this works!