How to format up to 2 decimal places in DAX using FORMAT()

[Anonymous]

Hi All,

I am trying to dynamically change the currency symbol according to the currency selection in the slicer.

I am using the FORMAT function to display currency according to the currency selected in slicer

FORMAT(MeasuretoFormat,"$#,##0.##")

results as:

How to Format it up to 2 decimal places? so the value $1364. should be displayed as $1364.00

[amitchandak · Accepted solution]

@Anonymous , Try like

FORMAT(MeasuretoFormat,"$#,##0.00")

[LittleBigBro03]

Hello,

What if I want to format up to one decimal number?

For example. it is now showing like 85.32%

I want to change it to 85.3% using format in dax

Thank you in advance!

[Mudassar5613]

= FORMAT(MeasuretoFormat,".#%")

[Anonymous]

Hi @amitchandak 
That worked. Thanks a lot👍