HI i attached excel workbook , it is having branchdata and exrate sheets . i need to add USD , EUR columns in branchdata sheet with help of power query , exrate should matched with branchdata bccode and Period . how is it please
HI i attached excel workbook , it is having branchdata and exrate sheets . i need to add USD , EUR columns in branchdata sheet with help of power query , exrate should matched with branchdata bccode and Period . how is it please
Please update your forum profile. It says Excel 2007and I doubt that is correct.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If I am understanding your request, then you will need to join the two tables on the date and BCCode. I have done this in the attached.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks