Hello Mr. Excel Forum Community,
I have been reviewing articles and working on dissecting how I need to build the relationship to construct a Power Pivot. I have one table that contains the Identifier along with a business process mapping; each identifier can belong to many business processes. I have another table that contains the identifiers tied to a time/change and I want to relate this table to see how many of these Identifiers are tied to the Business Process. In reading the article I believe I need to create another table that just has the identifier and remove the duplicates and then delete that to the other two tables - is that right? The power pivot needs to show the distinct count of EPR ID's belonging to the business process. The following links are those to the tables: <a href="http://www.lizandmike.net/excel/map%20to%20business%20process.xlsx">Map this</a> to the <a href="http://www.lizandmike.net/excel/business%20process.xlsx">Business Process Table</a>.
Thank you!
I have been reviewing articles and working on dissecting how I need to build the relationship to construct a Power Pivot. I have one table that contains the Identifier along with a business process mapping; each identifier can belong to many business processes. I have another table that contains the identifiers tied to a time/change and I want to relate this table to see how many of these Identifiers are tied to the Business Process. In reading the article I believe I need to create another table that just has the identifier and remove the duplicates and then delete that to the other two tables - is that right? The power pivot needs to show the distinct count of EPR ID's belonging to the business process. The following links are those to the tables: <a href="http://www.lizandmike.net/excel/map%20to%20business%20process.xlsx">Map this</a> to the <a href="http://www.lizandmike.net/excel/business%20process.xlsx">Business Process Table</a>.
Thank you!
