Fromat of thousand seperator when concatenating with text

[amaleranda]

Hi DAX Gurus, 

I have a simple thing that I cannot achieve. I have created below measure  

Tonns =

VAR St =

CALCULATE(

SUM(Summary[ActualTonnes])

)

RETURN

IF(

ISBLANK(St),

"Failed",

FORMAT(ROUND(St,0) & "t", "#,0")

)

At the moment the output is like 25432t. My desiered output is 25,432t. The number with a thousand seperator.

Your help is highly appriciated.

Thanks in advance

[MFelix · Accepted solution]

Hi @amaleranda,

You need to take the t from outside the format or placed with the ".

Something like this

Option1
FORMAT(ROUND(St,0) , "#,0 t")

Option2
FORMAT(ROUND(St,0), "#,0") & "t"

Regards,
MFelix

[amaleranda]

Works magic 🙂 thanks a lot