Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
thmonte
Helper IV
Helper IV

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?

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

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...

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
AnthonyTilley
Solution Sage
Solution Sage

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

cur.png

 

just need to change the text format to your desired output





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Greg_Deckler
Community Champion
Community Champion

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...

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

@thmonte 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.