Format function not showing Million Value to Decimal Point

[atul9063]

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.

[v-jiascu-msft · Accepted 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

[atul9063]

Thanks its working