cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
badger123 Member
Member

Different currency symbol using measure

Hello everyone! I am trying to create a measure that dynamically changes the currency symbol depending on the country selected in a slicer. It looks a bit like this at the moment: 

 

IF(SelectedCountry=1,"£"&Price,"$"&Price)

The problem with this is the number has lots and lots of decimal places, and ideally I just want it to show a whole number with the correct currency symbol, so rather than £16.1828490230 it would show £16. 

 

Is this possible? 

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
Super Contributor

Re: Different currency symbol using measure

Hi @badger123 

 

 In the place of Price, pls use INT( [Price] ). This will truncate the decimal part.

 

Thanks

Raj

2 REPLIES 2
rajendran Super Contributor
Super Contributor

Re: Different currency symbol using measure

Hi @badger123 

 

 In the place of Price, pls use INT( [Price] ). This will truncate the decimal part.

 

Thanks

Raj

Super User
Super User

Re: Different currency symbol using measure

Hi @badger123 ,

 

Change your measure to:

 

IF(SelectedCountry=1,Format([Price],"0£"),Format([Price];"0$"))

If you want to have decimal places make it like this

 

IF(SelectedCountry=1,Format([Price],"0.00£"),Format([Price];"0.00$"))

Be aware that instead of dot on the decimals can be comma depending on your regional settings.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 35 members 951 guests
Please welcome our newest community members: