Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
5 years ago
Solved

Customize format to million

Hi, I would like to customized format to million, but I want 0.7M for example rather than .7M as following.  Thanks  
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    YunJ 

     

    Try below format string

    #,##0,,.0M

     

nandukrishnavs's avatar
nandukrishnavs
Community Champion
5 years ago

YunJ 

 

Try below format string

#,##0,,.0M

 

AliceW's avatar
AliceW
Power Participant
3 years ago

It also works if you use it in a FORMAT function:

format('Measures Table'[Amount],"#,##0,,.0M")