Forum Discussion
Table Relationship Issues
Hi v-juanli-msft ,
Thank you for your response. I realized that I did not have a serial number listed more than once in my sample Sales Transaction data once I had left for the day and have now corrected. Thank you for realizing that.
All the training and dicussions I have had with others have advised to stay away using many to many relationships, which is why I did not use it. Are there any negatives that you have experienced with using Many to Many?
Thank you
could you also make a mockup in excel of how you want your table/output to look like?
Hi sturlaws ,
I want to be able to create a visual with detailed claim information only for each transaction serial number that has a claim, like v-juanli-msft replied with. Then, I will need to be able to apply filters from either the transaction or claim table to see the applicable data. I will also be creating quite a few measures like % of serial number sold had claims within xx time frame and do measures/counts on the different claim types. The more I read on the many to many relationship, I think this will work. I am currently trying to validate data to make sure it is correct with the many to many relationship.
Thank you - szub