Help with FORMAT

[Anonymous]

Hello all!

I created a calculated column to format other column with some Net Sales values.

test = FORMAT(Summary[Y5 NS (USD)];"$#,##0,,M")

Basically, if I have a value of $ 17.086.863 , format returns $17M.

But, if I have $ 3.500.000 , format returns $4M.  But I need $3.5M.

Any idea how to solve this?

Best Regards,

[Anonymous]

I don't know if it's the best solution, but instead of using FORMAT, I created a calculated column with the following expression:

Test3 = "$"&ROUNDDOWN(Summary[Y5 NS (USD)]/1000000;1)&"M"

[amitchandak]

@Anonymous , @parry2k has provided the solution. You can also refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[parry2k]

@Anonymous try this

test = FORMAT(Summary[Y5 NS (USD)];"$#,##0.00,,M")

[Anonymous]

Hello @parry2k 

Did not work :S

$3.500.000 become $3,500,00.00M

$17.086.863 become $17,086,863.00M