ifelse statement in DAX

March 25, 2024

I am trying to create a calculated column using the code below. Lookup function works find until I added the IF statement above it. What I need is to fix the outcome to 1 when df[col] = "B0" or df[col] = "B1" otherwise outcome should give the lookup function result. how to get around with this ? many thanks in advance.

_FY23_AOP_Rate = 
 IF('df'[col] = "B0" || 'df'[col] = "B1", 
    1, 
    LOOKUPVALUE(
                    dimFX[FY23 AOP], 
                    dimFX[Currency Code], 'df'[Currency])
  
)

>Solution :

Are you just missing an enclosing quote after B1?

IF('df'[col] = "B0" || 'df'[col] = "B1", 
    1, 
    LOOKUPVALUE(
                    dimFX[FY23 AOP], 
                    dimFX[Currency Code], 'df'[Currency])
  
)