How to get values between two tables (connected ma...

Anonymous · ‎08-13-2019

Hi everyone

I load two seperate tables into Powerbi. A mastertable sheet and a FX currency rate sheet.

On the mastertable I have a column that lists all the various currencies that the figures are in. I need to convert them all to Euro.

In excel I did a vlookup between the mastertable and FX currency rate sheet to bring back the appropiate rate.

How can I do this in PowerBI?

Many thanks

Anonymous · ‎08-13-2019

Hi @Anonymous,

Can you please share your sample data... So that i will try to help you

Thanks & Regards,

B V S S

How to get values between two tables (connected many to many) vlookup