Excel Power Pivot Data Model

0 votes
I'm working on what I assumed would be a fairly straightforward data model in Excel (not Power Bi). I have three distinct tables (Parts, Equipment, and Configurations). Equipment is made up of parts, and configurations are made up of equipment. Then, I have two "allocation" tables that allocate Equipment to Configurations and Equipment to Parts.

See the picture in the attachment. This includes the unprocessed tables, the relationship from the data model, and the flawed pivot table.

I'm not obtaining the right values in the pivot table when I connect everything in the data model. I'm rather certain that Excel's data model's one-direction restriction is what's causing the problem. Exists a more effective method to model this data? or is there an alternative? I've read about cross filters, but do I need to create one for each field in my tables?
Nov 15, 2022 in Others by Kithuzzz
• 27,360 points
62 views

1 answer to this question.

0 votes
Here is the answer for your question: https://www.contextures.com/excelpivottableerrors.html
answered Nov 15, 2022 by narikkadan
• 50,440 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 22,940 points
494 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
7,313 views
0 votes
0 answers

Importing notepad data to excel (difficult split)

I want to transfer this data from ...READ MORE

Feb 18, 2022 in Others by Edureka
• 13,640 points
83 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 50,440 points
154 views
0 votes
1 answer

Using Multiple filters in DAX

CALCULATE is defined as CALCULATE(<expression>,<filter1>,<filter2>…) This means that you can ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,910 points
4,431 views
0 votes
1 answer

Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 50,440 points
655 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 50,440 points
250 views
0 votes
1 answer

Updating Powerpoint - Excel Link in Different Computer

You could look at the Excel shape's ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 50,440 points
118 views
0 votes
1 answer

Use Excel pivot table as data source for another Pivot Table

Press the keys Alt+D+P in a new ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 50,440 points
414 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP