Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Dividing in Power BI Always Wrong

Hello,

 

In my report, I'm trying to get the charges per day for my sales tickets by taking a column (datatype = currency) containing the total earnings and dividing by another column (datatype = decimal) which has my total working days. However, no matter if I use the DIVIDE function or simply the "/" operator, my results column always renders an incorrect value. I've manually calculated what the total per day should be manually on 3 different devices which gives me the correct answer except for Power BI. For instance, I have a total of $144,617.00 made with a working days amount of 2.38. Taking the division of that "manually gives me $60,763.45 but Power BI gives me $60,891.37 instead. Even creating measures does not work correctly. This is extremely perplexing. 

Status: New
Comments
v-lili6-msft
Community Support

hi

I have tested on my side, it wroks well.

11.JPG

 

 

and I calculate $144,617.00/$60,891.37 = 2.3749999

 

 i think the 2.38 in your dataset is the format of two decimal digits.

 

so the problem should be this:

12.JPG

I used column 2 =2.375009 and keep the format of two decimal digits, Now it shows 2.38

 

and then divide column, it show result 60891.1377

 

So just adjust it as below:

Column 3 = [total earnings]/ROUND([Column 2],2)
13.JPG
 
 
 
Regards,
Lin