Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I want to format a measure to millions without 'M'. Here under is the measure
Sales (Last Year) = CALCULATE(SUM(Query1[Gross Sales]),SAMEPERIODLASTYEAR(DimEnqDate[FullDate]))
I know this is the code for format
Column = FORMAT ( Table[Amount], "#,##0,,M" )
But how should I apply it on the measure above so that it works with at least 'M' for a starter?
I have tried this
Sales (Last Year) = CALCULATE(SUM(Format(Query1[Gross Sales], "#,##0,,M")),SAMEPERIODLASTYEAR(DimEnqDate[FullDate]))
and this
Sales (Last Year) = FORMAT(CALCULATE(SUM(Query1[Gross Sales]),SAMEPERIODLASTYEAR(DimEnqDate[FullDate])), "#,##0,,M")
but the visual becomes blank.
Solved! Go to Solution.
Hi @fasih,
I'd like to suggest you to take a look at following link to know how to customize format function.
Reference links:
Sample formula: it will format 100 million(100,000,000) as 100
test = FORMAT ( VALUE ( "100,000,000" ), "#,0,," )
Regards,
Xiaoxin Sheng
pls create a new calculated column and
Hi @fasih,
I'd like to suggest you to take a look at following link to know how to customize format function.
Reference links:
Sample formula: it will format 100 million(100,000,000) as 100
test = FORMAT ( VALUE ( "100,000,000" ), "#,0,," )
Regards,
Xiaoxin Sheng
Dear Xiaoxin Sheng,
What if I want to display one decimal after the 100M, for example:
100,000,000 as 100,0 or
1,203,000 as 120,3
Thank you!!!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |