Power BI Ignore Rounding in Money values

Question

Round values

Why does Power BI (Dax query) always round values?
Example: 12345.678 Power bi rounds to 12345.68

EVALUATE
ROW("TEST",FORMAT( 12345.678, "Currency") )

Would it be possible to have two decimal places and not round, like 12345.67 in money values?

Answer 1

You can use the floor function in DAX:

FLOOR(<number>, <significance>)  

So in your example:

EVALUATE
ROW("TEST",FORMAT( FLOOR(12345.678, 2), "Currency") )