Custom currency format?

[thmonte]

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?

[AnthonyTilley]

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 ret

Example

just need to change the text format to your desired output

[Greg_Deckler · Accepted solution]

I think they just released something in September for this:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2019-feature-summary/#customForm...

[thmonte]

This is great!  Thanks.  If only I could save and apply it to columns in the modeling tab!

[v-chuncz-msft]

@thmonte 

To help improve Power BI, you may give feedback at the bottom.