PowerPivot and vlookup

1 reply [Last post]
Fri, 12/17/2010 - 17:51
debbielefkowitz
User offline. Last seen 2 years 22 weeks ago. Offline
Joined: 12/17/2010
Posts: 1

Hi,

I have a table full of sales data.  Unfortunately, the data comes to me in "native" currencies. So, I'll have something like this:

Sale 1 - 15.00

Currency  - USD

Sale 2 - 20

Currency - French Franc

I need to be able to convert the second sale, 20 in francs to USD.

in the "old days' I would have created a vlookup that compared the currency key column to a vlookup table, then found the relevant sales figure and multiplied by a conversion number.

Can't do this in powerpivot.  I have setup my powerpivot tables so that the main table and the currency conversion table are related, but not sure what to do after that.

Thanks,

Debbie Lefkowitz

 

Lost VBA password for addin. ›
Top
Thu, 01/06/2011 - 05:58
#1
Support
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 06/02/2008
Posts: 15
Powerpivot

May be you can try creating a custom defined function in excel called CurrencyConvert. Like the one below.

Public Function GetMultiplier(OldCurrency, NewCurrency) As Double

On Error Resume Next

Application.Volatile

End Function

 

Top