Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Column = CONCATENATE(FORMAT([Column1],"Standard"),"")
Column = CONCATENATE(FORMAT([Column1],"Standard"),"")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |