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.
I am trying to create a column that is an equation of simple arithmetic of other columns in the same dataset. However when I hit enter the following appears: "The result of a conversion or arithmetic operation is either too large or to small." What can I do to fix this? I have tried to rewrite it and restart Power BI but it does not work when the same equation works with other similar datasets.
Use ROUND () (Dax) in the variables you are going to divide.
For example
VAR Numerator = ROUND ( SUM(Fact[Costs]) , 2 )
VAR Denomiantor = ROUND ( SUM(Fact[Sales] , 2 )
RETURN
DIVIDE ( Numerator, Denomintor )
Hi @Anonymous ,
I ended up doing the equation outside of Power BI. Thank you for your help!
Hi @Anonymous ,
Is your data type ‘Decimal’? If so, you can change your data type to ‘Whole number’ or control the number of decimals. You can refer to this blog and this one.
If not, please give me more details, so that I can help you better.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.