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         msExchRemoteRecipientType       Output
-214748364234359738368102OnPrem_SharedMailbox
-214748364221474836483OnPrem_UserMailbox
-2147481850858993459236OnPrem_RoomMailbox

 

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

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

5 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

  • zasya_'s avatar
    zasya_
    New Member
    2 years ago

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

  • 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 


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