Multiple if conditions

[zasya_]

Hi all.

I am trying to run a DAX command based on an If conditions based on multiples values.

msExchRecipientDisplayType	msExchRecipientTypeDetails	msExchRemoteRecipientType	Output
-2147483642	34359738368	102	OnPrem_SharedMailbox
-2147483642	2147483648	3	OnPrem_UserMailbox
-2147481850	8589934592	36	OnPrem_RoomMailbox

If dont match all  this conditions the output must be "OnPrem_Check"

[zasya_]

OnPremiseMailboxType =
SWITCH (
TRUE (),
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=34359738368 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=102, "OnPrem_SharedMailbox",
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=2147483648 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=3, "OnPrem_UserMailbox",
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147481850 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=8589934592 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=36,"OnPrem_RoomMailbox"
)

Looks like are working but I just need add the last option "OnPrem_Check"

[wdx223_Daniel · Accepted solution]

OnPremiseMailboxType =
SWITCH (
TRUE (),
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=34359738368 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=102, "OnPrem_SharedMailbox",
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=2147483648 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=3, "OnPrem_UserMailbox",
'05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147481850 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=8589934592 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=36,"OnPrem_RoomMailbox",

"OnPrem_Check"
)

[zasya_]

I tested with the "Swithch" funtion and isclose to work as expected I just need to add  "OnPrem_Check"

OnPremiseMailboxType =

   SWITCH (

      TRUE (),

      '05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=34359738368 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=102, "OnPrem_SharedMailbox",

      '05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147483642 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=2147483648 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=3, "OnPrem_UserMailbox",

      '05_AD_UsersDetails'[msExchRecipientDisplayType]=-2147481850 && '05_AD_UsersDetails'[msExchRecipientTypeDetails]=8589934592 && '05_AD_UsersDetails'[msExchRemoteRecipientType]=36,"OnPrem_RoomMailbox"

)

But looks like something is worong 

[zasya_]

I am rtying to run the Fx LOOKUPVALUE but I am not sure about the syntaxis.

[wdx223_Daniel]

try the function of LOOKUPVALUE, and let the last arguement as "OnPrem_Check"