Forum Discussion
error with IF statement
Dear,
I have a problem with the IF statement like this. How could I adjust to be right?
Hope you could help me!!
Thanks !!
Hi Anonymous
Your issue in the formula is based on the part where you are making the comparision between two values:
300 < [Net Value] < 700
In DAX this is not acceptable, you need to redo your measure, also instead of making IF within IF you should use the SWITCH measure that evaluates an expression against a list of values and returns one of multiple possible result expressions.
Try to redo your formula in the following way:
Net Value Level = SWITCH ( TRUE (); [Net Value] < 100; "<100"; [Net Value] < 300; "<300"; [Net Value] > 300 && [Net Value] < 700; "700"; [Net Value] > 700 && [Net Value] < 1000; "1000"; ">1000" )Regards,
MFelix
2 Replies
Hi Anonymous
Your issue in the formula is based on the part where you are making the comparision between two values:
300 < [Net Value] < 700
In DAX this is not acceptable, you need to redo your measure, also instead of making IF within IF you should use the SWITCH measure that evaluates an expression against a list of values and returns one of multiple possible result expressions.
Try to redo your formula in the following way:
Net Value Level = SWITCH ( TRUE (); [Net Value] < 100; "<100"; [Net Value] < 300; "<300"; [Net Value] > 300 && [Net Value] < 700; "700"; [Net Value] > 700 && [Net Value] < 1000; "1000"; ">1000" )Regards,
MFelix