Forum Discussion
Helper IFields
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
Helper IIf I transform both columns year and its values in 2 columns I will get many to many relationship because id_product in first and second table will repeat
Resolver IIs there no primary key on the Table1 ?
- Grizman
In Table 1 primary key is Id_transaction, but not a Id_product.
Id_product repeat in Table 1
- Grizman
In you recommended case scenario after unpivoted colums I cann't create relationship beetween two table.
Because column Id_product in Table 1 and after unpivoted column Id_product in Table 2 will not unique .
In Table 1 primary key is id_transaction.
Have your new ideŠ°?
v-qiuyu-msftCommunity Support
Hi Grizman,
Please review my previous post, I have created a pbix file based on the sample data in your original post.
What's the problem in your scenario now? I didn't see the id_transaction in your table data, please clarify sample data and your requirement.
Best Regards,
Qiuyun Yu- Grizman
Table 1 aditional have two columns:
Id_transaction
Datetime
Id_product in first table don't unique.
Do you undestand me?