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...
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
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi 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
atul9063Helper III
Helper IIIThanks its working