Forum Discussion
Table Relationship Issues
Hello, I have a sales by serial number and claims by serial number table and the only common field is the serial number. Both tables can have the serial number listed more than once for various ...
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