Formula to convert all values into GBP

[GH21]

Hi,

The data I'm using consists of values in USD, EUR and GBP. I would like to use a measure that converts the USD/EUR into GBP using an exchange rate of USD = 1.25 GBP. Could someone point me in right direction?

[Dhairya]

You can simply use the following measure to convert USD to GBP

MeasureUSDtoGBP = CALCULATE(SUM('Currency'[USD])*1.25)

This will give following output

Please mark my solution as accepted if it helped you.

[GH21]

Hi @Dhairya,

As some of the values are USD and some are GBP do I need to do some form of IF statement to see if we need to convert the value?

[Dhairya]

Yes you can use if statement and if there are more than 2 currency types you can also use SWITCH.