Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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"
@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 try this
test = FORMAT(Summary[Y5 NS (USD)];"$#,##0.00,,M")
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |