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.
Solved! Go to Solution.
Hello @san17680 ,
try the following
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Remove the last extra parenthese (line: 11)
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.