Forum Discussion

zasya_'s avatar
zasya_
New Member
2 years ago
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...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    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_'s avatar
zasya_
New Member
2 years ago
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's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

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"
)