Custom Column with multiple Conditions

[heygowtam]

How can write in DAX

IF [employment type] = "Full Time " && Start Date < [2022/07/01]  then it is "20"        ********(if employee started before july )*****
IF [employment type] = "Full Time " && Start Date > [2022/07/01] then it is (1.666 * Every MOnth)     **(If employee started after July)**
IF [employment type] = "Part Time " && Start Date < [2022/07/01] then it is  12,      ***(if employee started before july )**
IF [employment type] = "Part Time " && Start Date > [2022/07/01] then it is  (1 *  Every Month )    

[amitchandak · Accepted solution]

@heygowtam , Use Switch with True option in DAX , if power query use nested if then else

Switch(True(),

[employment type] = "Full Time " && [Start Date] < [2022/07/01] , "20" ,

[employment type] = "Full Time " && [Start Date] > [2022/07/01] , 1.66* Datediff([Start Date] , today(),month) ,

// Add others

)

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56