Forum Discussion
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 say I have a number values in a column of 80, 180, and 10,180
I want to show them in my reports as
80c
1s 80c
1g 1s 80c
I can easily text format htis but then when I put it into tables it doesn't give me sums. Was wondering if theres a better approach to use?
I think they just released something in September for this:
4 Replies
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
I think they just released something in September for this:
This is great! Thanks. If only I could save and apply it to columns in the modeling tab!
