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

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