Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to use FORMAT to get a measure to report to two decimal places. For example, £1.73M. However, the output is only showing £1.7M. It needs to be manually formatted because it will format part of a larger sentence.
Here is the formula being used. Any help would be appreciated.
FORMAT([value],"£#,##,,.0M"
Thanks.
Solved! Go to Solution.
Hi @vpatel55 ,
I think you need to 0s at the end to force the decimal places, instead of the #s earlier.
FORMAT([Value],"£#,,.00M")
Hi @vpatel55 ,
I think you need to 0s at the end to force the decimal places, instead of the #s earlier.
FORMAT([Value],"£#,,.00M")