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

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.