Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |