Forum Discussion
Power Query - merge based on compensation - issue with trailing decimals
I want to merge info together in Power Query based on Compensation. One table has a number listed as 2764.72 and the other has 2764.72000000003. How do I get rid of the trailing digits. both tabs have the format listed a 1.2.
1 Reply
Set the data type for both as Currency (i.e. the $ sign). That rounds all amounts to two decimals.
