cancel
Showing results for
Did you mean:
Frequent Visitor

## Applying 2 conditions to create the column

Hi All,

I have the data of the employees login, log out timing details, gender details.

I want to create the column as per the below conditions

If Emp Gender Is M and Log out time is before 3.30 pm then mark it as Early

If Emp Gender Is F and Log out time is before 3.20 pm then mark it as Early

OR ELSE Normal

i am able to apply any one if condition not able to apply 2 conditions.

2 ACCEPTED SOLUTIONS
Resolver II

Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

Resolver II

1. Create a column time.

time = IF(Sheet1[Gender]="M",3.30-Sheet1[log out],IF(Sheet1[Gender]="F",3.20-Sheet1[log out])
2. Create a column flag 2
Flag 2 = IF(Sheet1[Flag]="Early",Sheet1[time])

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly and Like the solution.

3 REPLIES 3
Resolver II

Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

Frequent Visitor

Thanks for reply i need one more column that late by hh:mm which is for the Female how many hours they logout before 3.20 and also for Male before 3:30 how many hours

ex: The female is logout by 3 pm so she departure early by 0:20 and if the male is logged out by 3 pm so the value should reflect as 0:30 (I need it both in single column)

plesase help

Resolver II

1. Create a column time.

time = IF(Sheet1[Gender]="M",3.30-Sheet1[log out],IF(Sheet1[Gender]="F",3.20-Sheet1[log out])
2. Create a column flag 2
Flag 2 = IF(Sheet1[Flag]="Early",Sheet1[time])

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly and Like the solution.

Announcements

#### Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

#### Power BI May 2023 Update

Find out more about the May 2023 update.