IF Condition with {} operator in powerpivot

[lprabhu1107]

Dear All,

I have following data

[TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="class: xl64, width: 64, bgcolor: transparent"]Origin[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Destin[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]BOM[/TD]
[TD="class: xl63, bgcolor: transparent"]DXB[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]DEL[/TD]
[TD="class: xl63, bgcolor: transparent"]SIN[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]HYD[/TD]
[TD="class: xl63, bgcolor: transparent"]LHE[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]DXB[/TD]
[TD="class: xl63, bgcolor: transparent"]BOM[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]SIN[/TD]
[TD="class: xl63, bgcolor: transparent"]DEL[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]LHR[/TD]
[TD="class: xl63, bgcolor: transparent"]HYD[/TD]
[/TR]
</TBODY>[/TABLE]

In column C i have used a formula to derive "true origin" in Excel 2010 as follows=if(or(a2={"bom","del","hyd"}),a2,b2).
Now how do i replicate the same formula in Powerpivot as it does not support{} operator?

 

[Syoodo]

I don't use Powerpivot but if all you need to do is loose the {} brackets then the formula can be rewritten as =IF(OR(A2="bom",A2="del",A2="hyd"),A2,B2)

 

[Jonmo1]

If you have more than just a few items inside the {}, then you can create a list of those items in a range, say E1:E10
And use
=IF(ISNUMBER(MATCH(A2,E1:E10,0)),A2,B2)

 

[scottsen]

I would use a SWITCH: SWITCH Function (DAX)