Forum Discussion

cz1750's avatar
cz1750
Frequent Visitor
8 years ago
Solved

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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    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"
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity 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's avatar
cz1750
Frequent Visitor
8 years ago

Hi,

 

Thanks for your reply  - that worked.

 

 

Thanks

 

John

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    cz1750,

     

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