Forum Discussion
Adam_Algar
Apr 27, 2021Copper Contributor
Multi-year Budgets vs. Allocations Power Pivot Table (from 2 different Excel tables)
Hello all, Long time excel user, first time poster. 🙂 I have attached example tables to facilitate an understanding of what I am trying to do. I am rather new to Power Pivot, Power Query (G...
Yea_So
May 15, 2021Bronze Contributor
I think the only way to do that is not through power pivot because the power in the power pivot is in creating relationships (one to many). With many to many your only recourse is to unpivot both tables in power query then merge append both tables then add a designation column to id which data is a budget data and which data is the allocation data to differentiate them, then create a normal pivot table to summarize them. the budget id will go in column as well as the designation (i.e Budget, Allocation, and the total between the two will be the variance have to make the allocation a negative number though
- Adam_AlgarMay 19, 2021Copper ContributorThanks, I will try this !