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 guys,
I'm facing a problem which I've never seen using Power BI and I have no idea why.
The problem is that I have created a calculated column with a basic calculation like this: "Euros / Weight / Quantity" and results have no completly sense.
What I firstly 've done, is to create a calculated table using group by and addcolumns DAX functions, once I've had the desired format, I've added a calculated column called Quantity to the calculated table, and last step, I've added a calculated column called €/Kg (last column of the image).
Where is the problem? €/Kg column is wrong! Look at the results in the image
For example, first row of the image:
1668,85 (EUROS) / 6600 (WEIGHT) / 0'03 (QUANTITY)
CALCULATOR | 8'42 |
Result in Power BI | 10'11 |
I'm literally... WTF
Thanks for any help
Solved! Go to Solution.
Working with decimals can be funny in places. Sometimes a number will display as rounded but systems will often keep the "true" figure. An easy test might be to update your formula to something like
Round(Euros, 2) / Round(Weight, 2) / Round(Quantity, 2)
See if that changes the output any.
Is Quantity a rounded figure? For example is the real figure on the first line 0.025 but its displaying as 0.03?
It's rounded to two decimals, yes, but in this case, "original" number is 0.03.
In my knowledge, this shouldn't affect, just decimals, right?
Working with decimals can be funny in places. Sometimes a number will display as rounded but systems will often keep the "true" figure. An easy test might be to update your formula to something like
Round(Euros, 2) / Round(Weight, 2) / Round(Quantity, 2)
See if that changes the output any.
That did the trick.
Thanks
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |