topic Re: Column Calculate is wrong in DAX Commands and Tips

Column Calculate is wrong

Blairena — Mon, 30 May 2022 03:48:40 GMT

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 is all conrect but I don't know why the result in this column is not right.

The Var as below but it should not be decimal point issue.

Hope there can has someone to solve my problem, apprecaited it!

Re: Column Calculate is wrong

tamerj1 — Mon, 30 May 2022 04:04:25 GMT

Hi Blairena

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

Re: Column Calculate is wrong

Blairena — Mon, 30 May 2022 06:10:10 GMT

Hi Tamerj,

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

Re: Column Calculate is wrong

tamerj1 — Mon, 30 May 2022 06:38:55 GMT

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?

Re: Column Calculate is wrong

Blairena — Mon, 30 May 2022 06:46:00 GMT

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.