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
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.
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.
