How to change the format of a measure?

[KMucching]

Hello, I want to change the format of a measure like this example:

Value: 1345164879.98

Format that I want: 1,345 M

I'm trying with this formula "#,###,, M" but it doesn't work, please help!

[Anonymous]

Hi @KMucching 

Did you use the following measure

Measure = FORMAT(1345164879.98,"#,###,,M")

After testing, it can work, you can refer to the following picture, but the data type of the number will become text.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KMucching]

Hi! Thanks for your answer and your time,

I did it like you said, but the problem is that the number is converted to text and I still have to do some operations with the number,

Regards,