Display $ and no currency sign for Local Currency

[Harsh]

Hello @SamSPAIN,

To convert the numbers to the thousands I’ve provided the link in the second post - “Convert number to Billions in DAX”. It shows how to convert the numbers into the “Thousands”, “Millions” and even “Billions”. Again, the link is provided below for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Note: To view the entire post, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

Convert number to Billions in DAX

Hello @Anu, Well actually to convert the numbers into the billions I had put 3 commas and a full stop as a decimal separator. For converting them into millions use only 2 commas and for thousands use only a single comma. I’m providing a screenshot below of the results that I’ve mentioned. [Billions Format - 2] I’m also providing a link that I used as an reference that provides an explanation about formatting the numbers (although they’re used in the Excel) but same concept was applied here …