Rounding of numbers to thousands without rounding up/down

[Rt123]

Hello, I am trying to get the right number format for some financial numbers.

e.g.   mymeasusre = 123,456,789.00

If I roundit to thousands with #,##0, - it gives me 123457 after rounding up at thousands.

Is there any way I could keep the number as 123456.

Any help would be appreciated.

[lbendlin · Accepted solution]

How about INT([Value]/1000)

[v-zhouwen-msft · Accepted solution]

Hi @lbendlin ,thanks for the quick reply, your thinking is exactly right, I also thought of another way to do it.

Hi @Rt123 ,

Use the following DAX expression to create a measure

Measure 2 = 
VAR _a  = LEFT(FORMAT([Measure],"0"),6)
VAR _b = VALUE(_a)
RETURN _b

[lbendlin · Accepted solution]

How about INT([Value]/1000)