convert if condition to switch

[san17680]

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

[Idrissshatila]

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]

Hi,

Thanks for your response,

it is throwing an error.

[Idrissshatila · Accepted solution]

Hello @san17680 ,

Yes remove the last ")"

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

Follow me on Linkedin

[san17680]

oops that was oversight on my part. it worked thanks

[DataVitalizer]

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