Currency conversion resulting in incorrect result when multiplied

[SherriF]

Hi!

I have a report that contains some per unit amounts in CNY. I have in place a formula to populate a conversion rate based on the date column. When I "convert" the CNY value to USD, formatting the result as currency with a fixed decimal of 2 places. My problem occurs though when I mulitply this converted per unit amount by the number of units. Power BI is multiplying the USD with 4 decimal places instead of the rounded 2. For example:

The CNY value is: 24.69

The conversion rate is: 0.14174

The per unit conversion formula is: 24.69 * 0.14174 = $3.4995 USD. Power BI rounds to $3.50 USD

I need to mulitply $3.50 * 60 units so the result is: $210.00 USD

Instead, Power BI is doing this: $3.4995 * 60 = $209.97 USD.

Is there a way to make the number in the USD Per Unit really be the rounded amount of $3.50?

[SherriF]

That worked perfectly! Thanks!

[sevenhills · Accepted solution]

Looks like you have to use the round, for each unit calculation first and then you can multiple the number of units.

In M Query, you can use Number.Round, Number.Round, ...

In DAX, you can use 
 ROUND, ROUNDDOWN, ROUNDUP ...