Hi,
I have "Invoices" table with the values in one currency (GBP) and I have created another table "Currency".
I was wondering if there is a way using Power Pivot to have a currency slicer, so that if USD or GBP is selected - it converts the "Amount" using the exchange rates in the "Currency" table?
I have attached my sample data and thanks in advance 