Forum Discussion
Custom Column with multiple Conditions
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 )
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
1 Reply
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