The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
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 ret
Example
just need to change the text format to your desired output
Proud to be a Super User!
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!
To help improve Power BI, you may give feedback at the bottom.
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |