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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Any idea about the format string for europen standard representation? example: 100.000,00

  • 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")