Forum Discussion

SGBaringa's avatar
SGBaringa
Frequent Visitor
2 years ago
Solved

Currency formatting

Hello PBI community,

 

Sorry for the silly question but I am having trouble formatting my currency value to look the way I want it.

 

I am trying to get a value that looks like this: 23 456 789

To this: £23,46ms

 

Any help would be appreciated. 🙂

Need Help
Tips and Tricks
  • Vallirajap's avatar
    Vallirajap
    2 years ago

    Try this,

    use the DAX formulae to convert the num in the currency formate.

     

    Measure =
    Var val = 23456789/10000
    RETURN
    FORMAT(val / 100, "£0") & "," &
            FORMAT(MOD(val, 100), "00ms")
     

     


    Mark this as a solution.

3 Replies

  • Vallirajap's avatar
    Vallirajap
    Resolver III
    2 years ago

    Try this,

    use the DAX formulae to convert the num in the currency formate.

     

    Measure =
    Var val = 23456789/10000
    RETURN
    FORMAT(val / 100, "£0") & "," &
            FORMAT(MOD(val, 100), "00ms")
     

     


    Mark this as a solution.
  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    2 years ago

    Hi SGBaringa, 
    No worries, You can create a calculated column for this or a measure like this:- 
    FormattedAmount =
    VAR Amount = 'YourTableName'[Amount]
    VAR FormattedValue = "£" & FORMAT(Amount / 1000000, "#,##0.00") & "ms"
    RETURN
    FormattedValue

    Hope this will help you. 

    Thank you.