Forum Discussion
Table relationships with a Master date table
I am by no means an expert, but I think what you need is a DIM PartMaster table. You could then join this table to your DailyStock table (1:many) and as well to your Invoice table (again a 1:many).
Then use PartNumber from this new Dimension table and your charts should react accordingly.
Good Luck and regards,
Just want to make sure I understand.
I need to create a reference table that houses the list of parts and then link the all invoices table and the daily stock quantity table to this reference table? Like below?
Then use the PartMaster Part as my slicer list?
Awesome! Thank you! I will try this out if i can get it to work.
When I attempt to create the relationship by dragging part to part my Power BI desktop locks up and eventually crashes.
Unfortunately, crashes are out of my area of expertise. Hope you can get that issue resolved.