Forum Discussion
relationship
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
hi,
This error message displayed by POWER BI DESKTOP means that it has duplicate values, check for duplicate records in the CURRENCY column, or in the COMMISION_CIRRENCY column. Or empty records in these columns.
send a sample of the data to help you.
Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
Dear Rfranca,
Thank you for your answer.
The problem is that you have a value per currency for each day.
So for a year, I have 365 values for GBP, USD and so on..
It's also possible that the exchange rate is the same for a couple of days..
So it isn't possible to make this relationship?
Best Regards,
Niek
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