Forum Discussion
Solved
Currency conversion resulting in incorrect result when multiplied
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 th...
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 ...
That worked perfectly! Thanks!