relationships

Hi all, I am fairly new to Power Pivot. I am having some trouble understanding filtering between related tables. I have my main table "Demographics", in which "Index" is Unique so: Index Role 1 Engineer 2 Engineer 3 Manager...

Just like the title states, I have multiple sheets that all contain tables with similar data that can all be connected via a unique identifier. What would be the best way of achieving this in excel? The above image is an example of the main sheet where all of my gathered data will go. I want...

Hello unsuccessfully tried to create relationships. I have 2 different table about say motivation and a table about risk. Both tables have a column with ID and also reporting period. I need to create a report where I can use data from both motivation and risk, and link the total value of both...

Hey guys, I am currently trying to build a database in Excel that contains all Green Climate Fund (GCF) projects. Recently the GCF published an API that allows internet users to access their project data through the following URL: https://api.gcfund.org/v1/projects. I used the "Get Data from...

Hello, I’m looking for some guidance on how to build my data set, so I can effectively use Power Pivot to present my results. In my attempts so far, I have come up against the challenge of many to many relationships when trying to create relationships between my tables. I have tried to create...

I have a Dimension Table and a Fact Table brought in by Power Query. In Power Query, I added a Calculated Column to each table named "Report_ID". I'm trying to create a relationship in Power Pivot for these tables, but I keep getting the error message that Power Pivot does not currently support...

Hi all, I have a database - about databases - so what it does is stores all information about the various databases that we run, table names, columns that are linked column sizes, descriptions etc. I have a System table that links to a MasterTable (table) and then a column table. The column...

I’m working on a PC using the Office 365 suite. I know that there are work arounds for this issue, but I am trying to understand Data Models better and thought this would be a great way to practice (as it needs to be done anyway), yet I’ve already gotten stuck! Here the problem: I have 2 tables...

Hi all, I have an existing database that needs to have a large number of records archived from various tables. In the future they will be archived according to a set of criteria, such as the age of the item and its status. My understanding is that I need to be very careful of respecting...

Hi I'm trying to join two tables together through a relationship but am having trouble. My data is of a Building (type text) , which has Floors and Rooms which can both be a mix of text and number names (type any). In order to create a relationship based on the Room column, I attempted...

So I have a workbook with multiple tabs of a sales report. It’s essentially the same report, but just for different departments. I utilized power query to query each tab, and then append it into one. I then send that append to a pivot table so I can combine my multiple sources into one neat...

Hi, I've got a data set that looks like the below Listing <tbody> Company Listing 1 Listing 2 Activity a (1) Activity b (1) Activity a (2) Activity b (2) Dan Dan's CDS Dan's Books Jan 30 Feb 12 April 9 Jan 20 Bob Bob's DVDs Bob's Plates Jan 2 March 8 Jan 2 Jan 30 </tbody> I would...

I have three data sources that I need to consolidate into a single data source: 1. A list of maintenance periods which are uniquely (no repeats) identified by 4 letters and 3 digits, for example CANS118. The Maintenance Periods mentioned in the data sources below will be listed it this list...

Hello All, When drilling into a pivot table that pulled data from SSAS cube not all the columns are being brought in. There are relationships with many tables but how to choose other columns?

Hi, Is there any method to sistematically show the project structure, data flow, tables, relationships and all sort of things related to my excel project?

Greetings: Novice here. I created 2 forms, one that collects customer information and the other collects company information. When the user inputs the customer information and hits the submit button, I would like that data to auto populate on the company form. I am not able to set up...

Hi All In order to progress with some MRP calculations is need to find the lowest level in which a manufactured item is used within a BOM structure, column C below. The raw data below shows the relationships between the Parent and Child Items in columns A & B. Items A, B and J return a low...

I was trying to use the Query Wizard and it said that my tables weren't related so I looked at the relationships and there are no longer any lines connecting my tables. I'm checking back through backups and they are missing there too until I get to backups I made in February 2017. However, I've...

Hi, I seem to have this problem in Excel Pro Plus 2016. Well, I have this problem too for Excel 2013. I think this is probably something simple that I'm missing and I hope you can help me. I can't seemed to make the PowerPivot I've created reflect the many to many relationships correctly...

I'm am a stuck newby in ACCESS. I haven't done anything in access before but know programming, VBA, and RDMS (some better, some passing). I have a Access database structure that I have designed and have had checked. My data is in spread sheet (2000 records) that I have reused some columns for...