Forum Discussion
atul9063
Helper III
Helper IIIFormat function not showing Million Value to Decimal Point
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.
Note: Above function working perfectly in excel.
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
2 Replies
v-jiascu-msftMicrosoft Employee
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
atul9063Thanks its working