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.
Looking for some assistance handling an if statement.
Everything in the highlighted area works however returns a NaN if Labor total has $0.00 in the field.
When adding the extra if statement "not highlighted" i keep getting an error.
example, calculatedlabor total / est sw = value "this part works" only when the calulatedlabortotal is a $0.00 then it does not work, so I add another if condition to try resolve this issue. (hope this makes sense)
Appreciate any feedback.
Hi,
Why are you using an AND function inside the IF function? Also, is the calculatedlabourtotal column a text column. If it is, then write "0", else just 0.
AND was added to try somethign different.
I guess to keep this simple is there a certain way to handle 0 divided by 0 using an IF Statment to return a value of 0?
Right now I am getting NaN as the result.
wrote:AND was added to try somethign different.
I guess to keep this simple is there a certain way to handle 0 divided by 0 using an IF Statment to return a value of 0?
Right now I am getting NaN as the result.
use DIVIDE function.
Nope, I don't get it. Sample data would be great to recreate.
It looks like you are using AND incorrectly though.
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |