Forum Discussion

niekdp's avatar
niekdp
Frequent Visitor
8 years ago
Solved

relationship

Hi!   I have two tables, the exchange rate per day for different currencys, and also a table with purchases currency per day: I would like to have the exchange rate next to the currency ...
Show and Tell
Tutorial Requests
  • Rfranca's avatar
    Rfranca
    8 years ago

    hi niekdp Anonymous

    The relationship of your tabs can be solved by combining the tables. Read the link below.


    Combining two queries in Power Query or in Power BI is one of the most basic and essential tasks that you would need in most of the data preparation scenarios. There are two types of combining queries; Merge, and Append.

     

    relationship-in-power-bi-with-multiple-columns

     

     

    Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
     
    Best Regards,
    Rfranca

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Im sure you wont be able to solve it by creating a relationship since you can have multiple values.

I think you could maybe create a calculated column in which you have the currency + the value from it corresponding to the transaction date. 

I am new to DAX so it will be better if someone  help you with this, but i think this might work.