Forum Discussion
Solved
Multiple if conditions
Hi all. I am trying to run a DAX command based on an If conditions based on multiples values. msExchRecipientDisplayType msExchRecipientTypeDetails msExchRemoteRecipient...
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"
)
I am rtying to run the Fx LOOKUPVALUE but I am not sure about the syntaxis.