Add data from other table

Anything related to PowerPivot and DAX Formuale
Itay
Posts: 1
Joined: Fri Feb 01, 2019 10:38 pm

Add data from other table

Postby Itay » Fri Feb 01, 2019 10:43 pm

Hello Everyone, I'm using PowerPivot at the excel (Not on the Desktop App),

What I'm trying to do is to create a PowerPivot table with Data from 2 diffrent tables. I Tried to create a releationship between the tabels with the Seller name, but i got an error message (need a monovalent coulmn).

Image

Thanks Guys!

PhilC
Posts: 219
Joined: Tue Sep 09, 2014 8:13 am

Re: Add data from other table

Postby PhilC » Tue Feb 05, 2019 9:10 pm

There are many suitable approaches depending on your model, maybe try this one:

Created a Seller Name table, which has a distinct list of values from the other two tables. You can then link each table to this lookup table, and put the Seller Name from the lookup table in the pivot, not the Seller Name from the original two tables (hide the Seller Name from the user).

1. Reference table 1, keep only Seller Name column
2. Reference table 2, keep only Seller Name column
3. Append above two tables, remove duplicates - this is your new lookup table

Cheers
Phil


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest

cron