Forum Discussion

powerinM's avatar
powerinM
Helper II
6 years ago
Solved

Dax Format

Hi: I would like to format the values in value column in Millions such as 1.2M or 1.23M (if the value is 1,230,000). However, the following syntax is currently chopping it off. Can you please let me know what would be the correct syntax to achieve my desired formatting?

 

 

 

Need Help
  • powerinM's avatar
    powerinM
    6 years ago

     

    Icey wrote:

    Hi powerinM ,

    You can change your column like this:

    Format_Amount = FORMAT('Table'[Value],"#,##,,.00M")

     

    Best Regards,

    Icey

     

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

     

    Thanks Icey. Can also please assist me in formating the values in thousands in similar manner ? highlighted in underline.

     

  • Icey's avatar
    Icey
    6 years ago

    Hi powerinM ,

    You can use this:

    Format_Amount = FORMAT('Table'[Value],"#,.00K")

     

    Best Regards,

    Icey

     

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

     

5 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi powerinM ,

    You can change your column like this:

    Format_Amount = FORMAT('Table'[Value],"#,##,,.00M")

     

    Best Regards,

    Icey

     

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

    • powerinM's avatar
      powerinM
      Helper II
      6 years ago

       

      Icey wrote:

      Hi powerinM ,

      You can change your column like this:

      Format_Amount = FORMAT('Table'[Value],"#,##,,.00M")

       

      Best Regards,

      Icey

       

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

       

      Thanks Icey. Can also please assist me in formating the values in thousands in similar manner ? highlighted in underline.

       

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi powerinM ,

        You can use this:

        Format_Amount = FORMAT('Table'[Value],"#,.00K")

         

        Best Regards,

        Icey

         

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

         

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi powerinM ,

     

    Is this problem sloved?
     
    If it is sloved, could you kindly accept it as a solution to close this case?  
     
    If not, please let me know.  
     
    Best Regards
    Icey