+ Reply to Thread
Results 1 to 2 of 2

Unable to create relationship powerpivot

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    tirana
    MS-Off Ver
    Excel 2007
    Posts
    8

    Unable to create relationship powerpivot

    I have 3 tables, basic but somehow I can't add relationship.

    In powerpivot diagram I can add but when analysing data on pivot table they don't work. Attached is the excel sheet. All tables are linked by ID.
    Table 1 has ID Is all unique. all items in table 1 can be found int table 2. But table 2 and table 3 have more aditiional items that those on table 1

    Report I am trying to create is a simple, but the pivot table is not working (i guess relationship although defined in powerpivot, are not working) because second lookup table items are repeated. In fact ID 1234511212341230 has only one email but it's repeated on the pivot table (imabe below)

    What I need is that pivot table to be as follow

    Row Items:
    Table 1D Table 2 emal Table 3 Amount *Total count*
    (report value can be count or anything, I will not use, I am interested in pivot rows only)


    My goal is to replace vlookups because in reality those 3 tables are very large large and I don't want to manual vlookup all the time.



    Untitled.jpg
    2.png
    Attached Files Attached Files
    Last edited by mexiro; 02-05-2021 at 03:48 PM. Reason: attachment

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,886

    Re: Unable to create relationship powerpivot

    You only have one relationship set up, and it's the wrong way round as your first table should apparently be on the 1 side, not the many side (although there are more Ids in the other tables). You will also need a value in the value field area.

    Since you don't appear to actually be aggregating data, I'm not sure why you are using PP at all - why not just stick to Power Query?
    Rory

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unable to create Table relationship
    By Misteruniverse in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-04-2020, 04:48 AM
  2. Replies: 1
    Last Post: 03-05-2020, 11:37 AM
  3. Unable to create relationship between table!
    By jp16 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2019, 04:46 PM
  4. Replies: 0
    Last Post: 07-08-2016, 12:20 PM
  5. PowerPivot Relationship Issue
    By kellyjo7 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-27-2015, 11:18 AM
  6. Unable to create meaningful relationship in Power Pivot
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-08-2014, 10:28 AM
  7. PowerPivot many to many date relationship
    By chaserracer83 in forum Excel General
    Replies: 1
    Last Post: 10-08-2012, 03:48 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1