many-to-many

  1. A

    Filters from many-to-many to one-to-many Power Pivot

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

    Difficulties in creating many-to-many relationships in PowerPivot

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

    Many-to-many Relationship Error

    Hello all. I am new to Power Pivot and am taking my first stab at it by uploading multiple data sets that show net revenue received for each company. I am having a difficult time creating a relationship between the net revenue columns for each data set. Instead, I receive an error saying "Net...
  4. B

    Getting around many-to-many relationship

    I have two tables of data in my Data Model: Table 1 Field Names <tbody> Faculty Name Scaling Factor Name Scaling Factor Value </tbody> Table 2 Field Names <tbody> Activity Name Scaling Factor Name </tbody> I want to create a Pivot Table that shows: Activity Name (Row...
  5. L

    PowerPivot many-to-many relationships

    Good day My data lies in Table1 and Table2 as follow. "Users" are assigned several "Roles" and each "Role" give authorization to several "TCodes". This is a many-to-many relationship, which cannot directly be handled via PowerPivot relations. Which Calculated Measure (DAX) will allow me see...
  6. S

    DAX Many-to-Many OR ?

    Coleagues, i'm looking for a solution where with help of DAX formula I can retrieve data from fact table to another fact table joined over the same dimenssion table. The datamodel itself looks like: F_Table1->D_Table1<-F_Table2->D_Table2 So, what I need is to find: for every row of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top