Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated Column with multiple conditions

i have a table with following columns.                                                                                                Leave Details   EmployeeName      Leave taken days     Leave ...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may remove the equal sign (=) in expression below.

    'Leave Details'[Month diff]= -6,
ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

Anonymous

 

please try if formula instead of switch. It should fit your requirement. Thanks

Column = 
    if(Sheet2[leavetype]="a"&&Sheet2[leave taken days]>0,0,
        if(Sheet2[leavetype]="b"&&'Sheet2'[month diff]=6,Sheet2[month diff]-6
            ,if(Sheet2[leavetype]="c"&&Sheet2[leave taken days]>=5,Sheet2[month diff]-5,111)))