Forum Discussion

nannimora's avatar
nannimora
Helper I
7 years ago
Solved

calculation error on powerbi

Goodevening,  good evening,working on a power bi report, I noticed that there are calculation errors on a formula. or rather, sometimes the error is revealed other times not.   the formula is: ZZ...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi nannimore,

    Yes, based on your sample  data, I create a calculated column, this will get the result  like below

    So I am not sure how you get result 224181, you could try to recreate this column to see whether it works or not. Or check whether caused by your sample data(check whether this is 10 instead of 5)

     

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
7 years ago

Hi nannimore,

Yes, based on your sample  data, I create a calculated column, this will get the result  like below

So I am not sure how you get result 224181, you could try to recreate this column to see whether it works or not. Or check whether caused by your sample data(check whether this is 10 instead of 5)

 

Best Regards,

Zoe Zhi

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.