Convert Currency in Roman format

[Anonymous]

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).

how to achieve in Power BI?

Appreciated your inputs, anybody has already done this format

[Stachu]

try with FORMAT
https://docs.microsoft.com/en-us/dax/format-function-dax

https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function

[Anonymous]

Thanks, 

I have tried it, that is not giving as MM or M.

[Anonymous]

I have added a new column to bring the original column and it has  

IF(AND(Table1(Value) = "#,##0.00" ,
FORMAT((Table1[Value]/1000)) , "$#,0.00") & "M",
IF(Table1(Value) = "#,##,##0.00",
FORMAT((Table1[Value]/1000)) , "$#0,.00") & "MM",
& "#,0,.", $ "MMM"

it throws an error as 

Too few arguments were passed to the IF function. The minimum argument count for the function is 2.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Sorry typo error in the conversion part

NewColumn = IF(AND(Table1[Value]="#,##,##0.00", FORMAT((Table1[Value]/1000000), "$#,##,##0.00,,MM")), (Table1[Value] = "#,0.", FORMAT((Table1[Value]/1000), "$#,0.00" ) & "M" ))