Forum Discussion
Fields
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
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а?
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
Table 1 aditional have two columns:
Id_transaction
Datetime
Id_product in first table don't unique.
Do you undestand me?
Who can help?
Can anybody help me?
Grizman wrote:
Table 1 aditional have two columns:
Id_transaction
Datetime
Id_product in first table don't unique.
Do you undestand me?
Can you share sample data of those two tables and your expected results?
Best Regards,
Qiuyun Yu