Forum Discussion
Solved
Custom currency format?
I am build a report for a online gaming community and I was wondering if its possible to make up a custom format for values while still being able to do calculations of it. For example: Lets ...
I think they just released something in September for this:
Use a measure
in the measure decalre a veriable as a sum of your curancy amount
tehn decalre a second veraible to format this in the required output
then return the out put
in this way it will do all the sums before formating it to text
Measure =
var amt = sum('Table'[AMT])
var ret = FORMAT(amt, "##0g 00s 00c")
Return retExample
just need to change the text format to your desired output