Forum Discussion
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...
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.
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.
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.
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" )
If it solved your problem could you please mark it as the solution?
