DAX to output a text column from a number column, but formatted like a number

[johnnyaaron]

First, let me say the obligatory point, I'm new, I suck at this, mea culpa 🙂

I have one column that is a Decimal number format.  I want to take this number, format the number with commas, e.g. 1,234,567.00 , and then output that into a seperate column as text.

Format() doesn't appear to go to text, and I can't find a way to pickup the display format from the other column.  Answers?  Questions about my Question?

/////// Background:

I want to combine multiple caluclated tables with different number formats into one Matrix, for a KPI report.  I've got a UNION table going and go it all to happen, but I need more control over formats to give the table to the Executives.

[Greg_Deckler · Accepted solution]

Column = CONCATENATE(FORMAT([Column1],"Standard"),"")