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 ...
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.

     

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