Forum Discussion
Solved
login date based leave
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 ...
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.