Convert Currency

[Hayk]

Hello,

I have several columns which show various categories of revenues (e.g. Room Revenue, F&B Revenue, Other services Revenue).

The values are expressed in home currency (AMD), now I want to create a slicer of other currencies (USD, EUR, GBP) to enable me to

change the currency of my revenue columns. Is it possible to do this without adding double columns of the Revenue categories mentioned above?

Thanks;

Hayk 

[Anonymous · Accepted solution]

HI @Hayk,

I think at least you need a table with conversion rate for default currency. 

In addition, you can also take a looks at following about convert currency:

IF statement with SUM

Control which currency is displayed with slicer

Regards,
Xiaoxin Sheng