Forum Discussion

gauravsukhadia's avatar
gauravsukhadia
Frequent Visitor
5 years ago
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...
Need Help
  • sktneer's avatar
    sktneer
    5 years ago

    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's avatar
sktneer
Icon for Resolver I rankResolver I
5 years ago

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

  • gauravsukhadia's avatar
    gauravsukhadia
    Frequent Visitor
    5 years ago

    But if I put parenthesis then If the formula assumes calculation is over and state the next parameter you know what I mean. 

  • gauravsukhadia's avatar
    gauravsukhadia
    Frequent Visitor
    5 years ago

    Sorry, my bad I wasn't putting both parenthesis so it was showing the wrong result. You are the man, your solution worked. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      use DAX Formatter , just paste your code, it will format and inform where you are missing parenthesis.

      happy learning 🙂