Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
I have to display Value 71,672,885 as 71.6M and i m using below DAX
IF(Metric[EU]>=1000000,FORMAT(Metric[EU],"#,##0.0,,M")But its showing value as 71,672,885.0 M .let me know what i m missing in above dax dunction.
Solved! Go to Solution.
Hi @atul9063,
Please refer to format-function-dax and custom-numeric-formats-for-the-format-function. It should be something like below.
Column = FORMAT([Column1],"#,,.0M")
Best Regards,
Dale
Hi @atul9063,
Please refer to format-function-dax and custom-numeric-formats-for-the-format-function. It should be something like below.
Column = FORMAT([Column1],"#,,.0M")
Best Regards,
Dale
Thanks its working
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |