Format custom

[Dolly123]

You can tell me how to do in custom format like 23,345K 

[ogster1974]

1.Divide you measure by 1000

2.set your formatting to custom

3. add k to your format pattern and remove the decimal.

[Dolly123]

how to show only 5 digit of numbers in custom ?

[ogster1974 · Accepted solution]

This might be a nicer way to tackle what you're trying to do.

set the format pattern back to auto.

if(Sum(Sales)>1E6, num(Sum(Sales)/1E6,'$#,##0.000M')
 ,if(Sum(Sales)>1E3, num(Sum(Sales)/1E3,'$#,##0.000K')
 ,num(Sum(Sales),'$#,##0')
 ))