Forum Discussion
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
Hello san17680 ,
Yes remove the last ")"
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
5 Replies
- Idrissshatila
Super User
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 👍
- san17680
Helper II
Hi,
Thanks for your response,
it is throwing an error.
- DataVitalizer
Super User
Hi san17680Remove the last extra parenthese (line: 11)
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
- offline Spend travel type =