Display $ and no currency sign for Local Currency

[Harsh]

Hello @SamSPAIN,

Thank You for posting your query onto the Forum.

You can use the “FORMAT()” function to format your currencies in $. Just wrap the FORMAT() function around the SUM() part. So in general it’ll be like this -

Measure = 
Initial Criteria , 
FORMAT( SUM( 'OPEX Actuals'[Amount Budget Rate CY] ) , "$ #,##0.00" )

Note: When we make use of the “FORMAT()” function the figures get’s converted into the Text. I’m providing few of the links below pertaining to the queries asked for FORMAT() function. To view the entire post please click onto the link and not onto the “expand/collapse” button.

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

Thanks and Warm Regards,
Harsh

Can't change Format for Measure

Hello @YusufGillani, Thank You for posting your query onto the Forum. Well, the formatting part is greyed out because you’ve used the “FORMAT()” function in your measure. Once you use this function it converts the figures into the text format by default and sets that format. Second thing is, within that as well you’ve incorporated two different formats i.e. one for “Number” in terms of “0.00” and one for the “Percentages” in terms of “0.00%”. Due to use of “Characters” as well you won’t be abl…

Convert number to Billions in DAX

I understand the format function can be used, for thousand seperator etc, but i want it to look like “2.13B” say, I am not able to get this particular formatting.