Forum Discussion

Mark_Everett's avatar
Mark_Everett
Copper Contributor
Oct 07, 2020

Incomplete/incorrect relations between two tables in Excel Power Pivot Data Model

Greetings Excel Community - this is my first posting here..  Seeking expertise in building a Power Pivot Table leveraging two different tables of data loaded into the data model using the latest subs...
BI & Data Analysis
excel
cuong's avatar
cuong
Icon for Microsoft rankMicrosoft
Oct 10, 2020

Mark_Everett Did this help?  Please Mark as Best Response to help others with similar questions.  Thanks!

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 10, 2020

cuong , both are workable, it depends on context. If Mark is more comfortable with Power Query then definitely Riny_van_Eekelen  solution is the "best". If Mark prefers DAX manipulations then the second one.

 

In Excel practically everything could be done by several ways. Which one to prefer depends on concrete person preferences, expected efforts in maintenance, integration with other functionality which is not visible behind concrete question and just on emotions. 

 

At the same time, from supporting of this resource point of view (recognition, visibility, etc SEO stuff) it's better to have any "best" than no "best" at all. However, for visitors I'd recommend to check entire thread (in general, not this concrete thread) , not only the question and best answers but all discussion. That could help in concrete situation which could be slightly differ from mentioned in "best" answer.

 

Thus Mark_Everett , if you like MTC and willing to support it, please make your choice. That's business, not private.

Resources