Help with FORMAT

Question

Hello all!&nbsp;I created a calculated column to format other column with some Net Sales values.&nbsp;&nbsp;test = FORMAT(Summary[Y5 NS (USD)];"$#,##0,,M")&nbsp;&nbsp;Basically, if I have a value of $ 17.086.863 , format returns $17M.&nbsp;But, if I have $ 3.500.000 , format returns $4M.&nbsp; But I need $3.5M.&nbsp;Any idea how to solve this?&nbsp;Best Regards,&nbsp;

anonymous · Answer

I don't know if it's the best solution, but instead of using FORMAT, I created a calculated column with the following expression:&nbsp;Test3 = "$"&amp;ROUNDDOWN(Summary[Y5 NS (USD)]/1000000;1)&amp;"M"

parry2k · Answer

Anonymous&nbsp;try this
&nbsp;
test = FORMAT(Summary[Y5 NS (USD)];"$#,##0.00,,M")
&nbsp;

amitchandak · Answer

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

anonymous · Answer

Hello&nbsp;parry2k&nbsp;&nbsp;Did not work :S&nbsp;$3.500.000 become $3,500,00.00M&nbsp;$17.086.863 become $17,086,863.00M&nbsp;&nbsp;

Forum Discussion

Help with FORMAT

4 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Matrix formatting