Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
Hi @Blairena
Would you please add brackets to A/B*C*D to clarify your desired result?
Hi Tamerj,
Here is my desired result, (A/B)*C*D.
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?
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.
User | Count |
---|---|
13 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |