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,
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"
@Gdps , @parry2k has provided the solution. You can also refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
197 | |
68 | |
61 | |
58 | |
56 |
User | Count |
---|---|
189 | |
166 | |
87 | |
73 | |
70 |