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.
Hello,
what should be the proper formula if you have to calculate (A-B)B, if there a options that A and B are zeros, or only B is zero.
column = if(and('A=0,B=0), 0, (IF('B=0), 0, A/'B])
Would it be correct?
thanks in advance
Solved! Go to Solution.
Why dont you keep the formula as is (A-B)/B and if it gives you an error then convert the error to zero.
Simpler formula i think.
IFERROR( ([Sales]-[Target] / [Target]), 0)
SWITCH(TRUE(),[a]=0,0,[b]=0,0,[a]/[b])
This will only divide A by B if both aren't equal to 0, did I understand you correctly?
hi Tom,
actually the A -is the sales, and B - is the target sales, so it can be that that there's no sales which means no target
Why dont you keep the formula as is (A-B)/B and if it gives you an error then convert the error to zero.
Simpler formula i think.
IFERROR( ([Sales]-[Target] / [Target]), 0)
How about:
=IF([Sales]<>0;DIVIDE([Sales]-[Target];[Target]))
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |