Nested IF and OR n DAX

[cz1750]

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) )

         )

         OR

        (

           (Table[value1] = "III" 

       )

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

Thanks

John

[Zubair_Muhammad · Accepted solution]

@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]

Hi,

Thanks for your reply  - that worked.

Thanks

John

[v-chuncz-msft]

@cz1750,

By the way, you may help accept solution. Your contribution is highly appreciated.