Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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")
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |