Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am trying to dynamically change the currency symbol according to the currency selection in the slicer.
I am using the FORMAT function to display currency according to the currency selected in slicer
results as:
How to Format it up to 2 decimal places? so the value $1364. should be displayed as $1364.00
Solved! Go to Solution.
@Anonymous , Try like
FORMAT(MeasuretoFormat,"$#,##0.00")
@Anonymous , Try like
FORMAT(MeasuretoFormat,"$#,##0.00")
Hello,
What if I want to format up to one decimal number?
For example. it is now showing like 85.32%
I want to change it to 85.3% using format in dax
Thank you in advance!
= FORMAT(MeasuretoFormat,".#%")
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |