Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🙂
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |