login date based leave

[rajasekar_o]

hi,team
Login date based leave calculation  heare all day are working day
Employee

EMPID	NAME	DEPT
EMPS001	KUMAR	accounts
EMPS002	RAM	IT
EMPJ003	VANI	TESTING
EMP030	THAMO	accounts
EMP032	VINOTH	IT

login 

EMPID	LOGIN DATE	TIME	SHIFT
EMPS001	01-04-2024	6:00 AM	1
EMPS002	01-04-2024	6:00 AM	1
EMPJ003	01-04-2024	6:00 AM	1
EMP030	01-04-2024	6:00 AM	1
EMPS001	02-04-2024	6:00 AM	1
EMPS002	02-04-2024	6:00 AM	1
EMP030	02-04-2024	6:00 AM	1

expected output
if i filter the date 1/4/2024
Department wise leave

 

if i filter the date 2/4/2024
Department wise leave

employee wise leave details with
if i filter the date 1/4/2024

if i filter the date 2/4/2024

[DataNinja777 · Accepted solution]

Hi @rajasekar_o ,

You can achieve your required output in several different ways and one of them is as follows:

Leaves = [Countrows of employees]-distinctcount('Login data'[EMPID])

Next, identify 'Leave' where the Leave measure returns a value of 1.

Employee Leave = if([Leaves]=1,"Leave",blank())

The output is shown below:

I have attached a sample pbix file.