Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |