Forum Discussion
Solved
multiple if multiple conditions
Hello. I would need your help please with a bit complex multiple if statement with multiple conditions where I struggle with some issues. This is my dax: Rates = SWITCH( TRUE(), ...
Hi, vbis ;
The last DAX can be simplified to and could try it.
Rates = IF ( ( Clothes[Color] IN { "White", "Black" }&& [Units Sold] = "Low" ) || Clothes[Color] = "Grey", SWITCH ( [Size], "Small", "5", "Medium", "10", "Large", "15" ), "null")
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, vbis ;
The last DAX can be simplified to and could try it.
Rates =
IF (
( Clothes[Color] IN { "White", "Black" }&& [Units Sold] = "Low" )
|| Clothes[Color] = "Grey",
SWITCH ( [Size], "Small", "5", "Medium", "10", "Large", "15" ),
"null")
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello.
Thank you for your response.
I tried this dax and i got the message:
"Something went wrong. There's not enough memory to complete this operation. Please try again later when there may be more memory available."