Forum Discussion
Solved
Calculated Column ( Order of Calculation trouble )
Hi Team, I have unique problem where Power BI Calculated column returns wrong result and not as per formula. Second Part of My formula is trying to say give me weight of each product if prod...
In the actual formula, you are missing parenthesis as used in your following manual calculation so the order of calculation would be different.
(edge_width*2-thickness)*thickness*length*0.0075*quanity
sktneer
Resolver I
Resolver IIn the actual formula, you are missing parenthesis as used in your following manual calculation so the order of calculation would be different.
(edge_width*2-thickness)*thickness*length*0.0075*quanity
Sorry, my bad I wasn't putting both parenthesis so it was showing the wrong result. You are the man, your solution worked.
use DAX Formatter , just paste your code, it will format and inform where you are missing parenthesis.
happy learning 🙂