Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SGBaringa
Frequent Visitor

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

1 ACCEPTED SOLUTION
Vallirajap
Resolver III
Resolver III

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")
 
Screenshot (164).png

 


Mark this as a solution.

View solution in original post

3 REPLIES 3
grazitti_sapna
Resolver III
Resolver III

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
Resolver III
Resolver III

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")
 
Screenshot (164).png

 


Mark this as a solution.

Thank you! 🙂

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.