Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear,
I have a problem with the IF statement like this. How could I adjust to be right?
Hope you could help me!!
Thanks !!
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsDear,
Thank you for solution and spending time to help!
it works perfeclty!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |