Forum Discussion
nmoriello
1 year agoFrequent Visitor
Shippable Inventory Dax & Matrix
Hello, I have a Power BI Report that is using 4 different tables (Order Backlog, Inventory, Incoming Shipments & Production) I am trying to leverage all 4 tables to see what amount of inventory to f...
parry2k
1 year agoSuper User
nmoriello can you share relationship diagram and what columns you are using on the rows.
nmoriello
1 year agoFrequent Visitor
Since I have multiple Companies on each table I created a unique link (PartNum Link). That each table in the diagram below is linking to the Part Table. That allows me to geat to each part from the tables.
As for the Matrix I am using the PartNumber as the bottom value, then above that I am using a PartCategory field that lives on that same Part Table.