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.
Hi, asking for your help how to fix this. I'm getting an error "Divide by zero encountered" when loading my data. This is the calculations I think that causing the error. The calculated column is working but my whole dataset is not loading properly. Thank you
z Payments Calculated Amount = SWITCH( TRUE(),
[Line Amount Types] = "Inclusive" && [Type] = "ACCREC",
(([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Inclusive" && [Type] = "ACCPAY",
(0-([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
0)
I tried using the DIVIDE() function but still getting the same error.
Solved! Go to Solution.
@kristel_tulio , Remove this column and check, this may be because of something else. In case you are using query in Power bi or View at source, check those too
@kristel_tulio , Remove this column and check, this may be because of something else. In case you are using query in Power bi or View at source, check those too
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |