excel Nested Or with multiple variables

[WILDFLOWER92]

What would be the equivalent in powerpivot? Switch statement?

=IF(OR([fromairportcode]={"YYZ","YVR","YUL","YYC","YEG","YQB","YOW","YWG","YXU","YHZ","YXE","YQR","YYJ"}),"Canada",IF(OR([fromairportcode]={"BOS","EWR","JFK","LGA","NYC","PHL","PIT"}),1,IF(OR([fromairportcode]={"ATL","BWI","CLT","ORD","CLE","DFW","DEN","DTW","IAH","MCI","MIA","MSP","MCO","RDU","STL","TPA","WAS","DCA","IAD"}),2,IF(OR([fromairportcode]={"LAX","PHX","PDX","SLC","SAN","SFO","SEA"}),3,"OTH"))))

 

[scottsen]

DAX, of course, supports AND/OR/Switch, but it seems more likely to have a table structure that better supports what you are trying to do. A separate column for "country" or whatever you got going on there.