Nested IF and OR n DAX

Hi,

I have been trying to add calcualted columns in Power BI but I keep getting it wrong. Does anyone know how to create a calcualted colum that is based on IFs and Ors like the following?

If (Table[value1] IN ("ABC","DEF,"GHI") AND Table[value2] = 200 ) THEN
'Type A'
Else If (

(Table[value1] = "GGG" AND Table[value2] IN (100,300) )

)

(

(Table[value1] = "III"

)

THEN
       'Type B'
Else
'Type C'
End If

Thanks

John

try

Column =
IF (
    'Table'[value1] IN { "ABC", "DEF", "GHI" }
        && 'Table'[value2] = 200,
    "Type A",
    IF (
        'Table'[value1] = "GGG"
            && 'Table'[value2] IN { 100, 300 },
        "Type B",
        "Type C"
    )
)

3 Replies

Zubair_Muhammad
Community Champion
8 years ago
cz1750

try

Column = IF ( 'Table'[value1] IN { "ABC", "DEF", "GHI" } && 'Table'[value2] = 200, "Type A", IF ( 'Table'[value1] = "GGG" && 'Table'[value2] IN { 100, 300 }, "Type B", "Type C" ) )
- cz1750
  Frequent Visitor
  8 years ago
  Hi,
  
  Thanks for your reply - that worked.
  
  Thanks
  
  John
  - v-chuncz-msft
    Community Support
    8 years ago
    cz1750,
    
    By the way, you may help accept solution. Your contribution is highly appreciated.

Forum Discussion

Nested IF and OR n DAX