Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get Exchange Rate By Merging Tables Based on the Closest Date

Dear All,   I'm new to PowerQuery and I need your help. As you can see, I have a table with my Orders (named: OrdersSA18_PowerBI) and another with my Exchange Rates (named: Exchange Rate Table) I w...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    In that case you can create a Index Column in both the tables and then merge those two tables.
    1)Create Index Column in both tables by going to Add column->Index Column.
    2)Perform Merge operation and select Index Columns from both tables.


    Let me know if it works.

    Thanks,
    Sanket


    If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes, I had already achieved this solution using Dax, but I need this to be done in PowerQuery if it is possible of course. Thank you anyway for your fast answer.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

In that case you can create a Index Column in both the tables and then merge those two tables.
1)Create Index Column in both tables by going to Add column->Index Column.
2)Perform Merge operation and select Index Columns from both tables.


Let me know if it works.

Thanks,
Sanket


If this post helps, then mark it as 'Accept as Solution' and give it a thumbs up.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    It works. Thank your for your help 🙂