Solved: DAX format function

FZOU · ‎03-02-2021

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 · ‎03-02-2021

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎03-02-2021

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

DAX format function

Helpful resources

Power BI Monthly Update - October 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - October 2024

How to Get Your Question Answered Quickly