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
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. 🙂
Solved! Go to Solution.
Try this,
use the DAX formulae to convert the num in the currency formate.
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.
Try this,
use the DAX formulae to convert the num in the currency formate.
Thank you! 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
84 | |
76 | |
64 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |