relationships

  1. G

    Power Pivot guidance - data structure and avoiding many-many relationships

    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...
  2. L

    Power Pivot Error "Many to Many" Error Is Incorrect

    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...
  3. J

    Derive relationships based on data

    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...
  4. J

    Creating Relationships (of person's name) in a Data Model where 2 people have the same name (but different bdays)

    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...
  5. A

    Advice for Archiving, Set Up Table Relationships First?

    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...
  6. M

    Problem creating unique values to create a relationship

    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...
  7. G

    confused about relationships to appended query

    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...
  8. M

    Data Set with multiple dates - needs calendar pivot table

    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...
  9. P

    How to combine datasets

    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...
  10. iknowu99

    Excel Pivot Drill Down from SSAS

    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?
  11. F

    Project's documentation

    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?
  12. B

    Copying information from one for to another

    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...
  13. D

    VBA to find Hierarchy Low LEvel

    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...
  14. R

    Lost relationships between tables

    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...
  15. F

    PowerPivot and many to many relationships not working

    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...
  16. C

    Getting bulk data into Access

    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...
  17. Q

    PowerPivot relationships not working after Power Query

    Hi everyone, This one is hard to explain, but it seems like my relationships are not working correctly in Powerpivot. I have 3 tables in my Excel file which I made changes to in Power Query. From 1 table I made a another custom query which removed all duplicates and only gets the unique...
  18. C

    Comparing data from two sheets, find the matches

    Hi, let me start by saying I don't know much about excel. I don't work with it regularly but I was asked to try and figure something out for my boss. I have exported data from two separate sources, there is very little in common between the two except for the customer names and the amounts...
  19. G

    PowerPivot relationships

    I have problems creating the appropriate relationship and consequently cannot display my data as I want to. I have the following tables with lots of data created from csv. It is very hard to alter these files as they come in ready. table 1 Calendar table: full-Date, day, month, year, ... table...
  20. N

    Excel 2013 Relationship Table Cannot working

    i have 2 Table RM Table AM Table Relationship My problem is Must Be show Region Name > RM Name EN >AM Name EN Bkk+CW > Somsak Wattanasanasena > Chaowalit Siriketgon but it show all list in AM Table Answer

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top