Forum Discussion

heygowtam's avatar
heygowtam
Helper II
3 years ago
Solved

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 " &...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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