Forum Discussion

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost 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
Icon for Community Champion rankCommunity Champion
5 years ago

YunJ 

 

Try below format string

#,##0,,.0M

 

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
3 years ago

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

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