Dax Format

[powerinM]

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?

[powerinM · Accepted solution]

---

@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]

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

[Ashish_Mathur]

Hi,

This one works

=FORMAT(Table1[Value]/1000000,"#,##0.00,,M")

[Icey]

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 · Accepted solution]

---

@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 · Accepted solution]

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.