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
• 38,000 points
753 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
• 63,640 points

Related Questions In Others

0 votes
1 answer

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
• 38,000 points
345 views
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
• 23,260 points
7,846 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,690 points
13,996 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,690 points
366 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,850 points
8,238 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
• 63,640 points
3,383 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
• 63,640 points
1,258 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
• 63,640 points
817 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
• 63,640 points
14,173 views
0 votes
1 answer
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