Forum Discussion
Solved
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 ...
Try this,
use the DAX formulae to convert the num in the currency formate.Measure =Var val = 23456789/10000RETURNFORMAT(val / 100, "£0") & "," &FORMAT(MOD(val, 100), "00ms")
Mark this as a 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.
Thank you! 🙂