Fairly new to power queries and finding my feet largely by trial and error.
I have an Excel file with two tables, “ModelName” is one
and “Vendors” is the other.
Table “ModelName” column “Model” contains unique values (one to one)
Table “Vendor” column “Model” contains the same names as the above table, but it has duplicate values (marked in red above) because I could potentially have the same Model containing a different Vendor or Controller (one to many).
I have created Queries & Connections and loaded/ added them to the Data Model. I have also created a relationship between the two data models
But apparently, this isn’t working:
I was wondering if there is someone willing to point me in the right direction. What I am trying to do is to create one PivotTable from “ModelNames” which would contain “Model” and “12 Month Volume”. Then I would use all these slicers from “Vendor” and be able to filter the data from "Vendor" (which works fine) as well as the data/ Pivot Table from "ModelNames".
