Currency formatting

[SGBaringa]

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

[grazitti_sapna]

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.

[Vallirajap · Accepted solution]

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.

[SGBaringa]

Thank you! 🙂