Forum Discussion
Help with FORMAT
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.08...
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"