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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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