Forum Discussion

bbdiver526's avatar
bbdiver526
Frequent Visitor
8 years ago
Solved

IF formula with multiple conditions

I'm relatively new to PowerBI and DAX statements and I'm having an issue with writing an IF statement with multiple conditions.   I need to use the Volume if it is current year, type is Actuals and...
Need Help
  • anandav's avatar
    anandav
    8 years ago

    bbdiver526,

    AND function can take only 2 parameters.

    Check the documentation.

     

    You will need to chain the AND operator && to achieve what you want.

    e.g.

     

bbdiver526's avatar
bbdiver526
Frequent Visitor
8 years ago

anandav,

Thanks for the info. It seems to be working now. I'm not familiar with DAX syntax having just started using it and your response was helpful. I appreciate it.

dexterz's avatar
dexterz
Helper II
8 years ago
SWITCH (
    TRUE (),
    Product[Size] = "XL" && Product[Color] = "Red", "Red and XL",
    Product[Size] = "XL" && Product[Color] = "Blue", "Blue and XL",
    Product[Size] = "L" && Product[Color] = "Green", "Green and L"
)
  • anandav's avatar
    anandav
    Skilled Sharer
    8 years ago

    dexterz,

    Didn't know about using the True() function in SWITCH. Read up on it after I saw your post. Cool!