Forum Discussion
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...
Thanks very much for this detailed response. I have tried it, and while I am sure it would work in newer / updated versions, it sadly seems to fall apart at the "treatas" DAX part, meaning it doesn't exist in my version. Not likely to be able to resolve this version problem any time soon unfortunately.
Great response though, thanks again!
Great response though, thanks again!
If TREATAS is not supported by your version you may use some equivalent
Available Budget Variant:=CALCULATE (
SUM(AvailableBudgets[Available]),
FILTER( ALL(AvailableBudgets[Budget source]),
CONTAINS(
VALUES(Allocations[Budget source]),
Allocations[Budget source],
AvailableBudgets[Budget source]))
)
It returns the same result
CONTAINS shall be available, that's quite old function.