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.

anandav's avatar
anandav
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

bbdiver526,

If it solved your problem could you please mark it as the solution?