Forum Discussion

san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago
Solved

convert if condition to switch

hi,

i have this if condition which does the job for me

offline Spend travel type = IF(AND(TABLE[Travel Type]="Air",TABLE[Online/Offline]="Offline"),TABLE[Air_Spend],

                if (and(TABLE[Travel Type]="Rail",TABLE[Online/Offline]="Offline"),TABLE[Rail Spend],

                if(and(TABLE[Travel Type]="Hotel",TABLE[Online/Offline]="Offline"),TABLE[Hotel Spend])))

 

it basically identified offline spend by travel type (air or rail or hotel)

 

Just want to convert this to switch function in power bi.

 

Please advise.

Thanks

5 Replies

  • Hello san17680 ,

     

    try the following

    • offline Spend travel type =
      SWITCH (
      TRUE (),
      TABLE[Travel Type] = "Air"
      && TABLE[Online/Offline] = "Offline", TABLE[Air_Spend],
      TABLE[Travel Type] = "Rail"
      && TABLE[Online/Offline] = "Offline",
      TABLE[Rail Spend] < TABLE[Travel Type] = "Hotel"
      && TABLE[Online/Offline] = "Offline",
      TABLE[Hotel Spend]
      )

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

    • san17680's avatar
      san17680
      Icon for Helper II rankHelper II

      Hi,

      Thanks for your response,

      it is throwing an error.

      • DataVitalizer's avatar
        DataVitalizer
        Icon for Super User rankSuper User


        Hi san17680 

        Remove the last extra parenthese (line: 11)

        Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated