Forum Discussion

rajasekar_o's avatar
rajasekar_o
Icon for Helper V rankHelper V
2 years ago
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 ...
Need Help
Tips and Tricks
Tutorial Requests
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    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.

     

     

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

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.