Forum Discussion
chahine
Aug 26, 2021Iron Contributor
Data model relations not working properly in power pivot
Hi when doing relations i had some strange results, although same when i did in power bi it worked i have 2 tables of customers one with unique values & one with duplicates, so when i made the re...
- Aug 26, 2021
If you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.
SergeiBaklan
Aug 26, 2021Diamond Contributor
If you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.
machag
Oct 25, 2024Copper Contributor
SergeiBaklan Thank you