I could not believe this when I found it purely by accident. If you have ever wanted to divide your number by 1000 or a million before displaying it, no need to create another measure that does your division and rounding, you can simply format your number as custom with the following:

eg. say you want to show 1,234,567.89 in thousands  or millions

Custom format: 0,0.00,K

will appear as 1,234.57K

Custom format: 0,0.00,,M

will appear as 1.23M

That trailing comma, or commas, does the magic. You can divide by billions too by adding a third comma.

I was so happy to find this while making a typo in my number formatting

Dave