Forum Discussion

Blairena's avatar
Blairena
Regular Visitor
4 years ago

Column Calculate is wrong

Hello,    I need to calculate A/B*C*D, and all the calculated amount in excel is right when I download the form from Power BI to check the result.  Below is my fomula and the Values of A, B, C, D ...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Blairena 

Would you please add brackets to A/B*C*D to clarify your desired result?

Blairena's avatar
Blairena
Regular Visitor
4 years ago

Hi Tamerj,

 

Here is my desired result, (A/B)*C*D. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Blairena 

    Then your formula is correct. I have no idea why you're getting wrong numbers! you are creating a calculated coulmn, right? And all all of them are coulmns? No measures?

    • Blairena's avatar
      Blairena
      Regular Visitor
      4 years ago

      tamerj1 

      Hi,

       

      I have separated the formula, and founded that A/B is correct, and when it comes to (A/B)*C, the result shows wrong, C column formula as below. 

      Actually all the columns has formula, but I just founded that the wrong result comes here and don't know why.