Forum Discussion
Convert Currency in Roman format
Hi, The client has asked to display the Currency format to display as 1499.99 as 1.5M, not 1.5K 1593284333 as 159.29 MM and BIllions in MMM format not as Power BI Default format(K, M, bn)...
The DAX Currency function help as
Column1 = FORMAT ( Table[Amount], "#,##0,,M" )
Column2 = FORMAT ( Table[Amount], "$#,##0.00,,MM")
if we add together it omits one format,
I need both values of $1#### as $1M
and $9######### as $900MM format also.
appreciated your inputs
Roman Currency Formats
How to change the default currency format like Thousand K to M and Millions as M to MM & Billions as MMM? Anybody has changed? appreciated your inputs