DAX format function

[FZOU]

Hello,

Can any one help me to have thousand separator in this dax formula please ?
I want to add separator to the second card like first one.

Thank you 🙂

[amitchandak · Accepted solution]

@FZOU , Try like

"Total " & format(sum('Total Resource'[resources]), "#,###") & " K"

or

"Total " & format(sum('Total Resource'[resources])/1000, "#,###") & " K"

Refer the below portion of the blog for formats

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings