Forum Discussion
Lookup for multiple columns and multiple values
I have tables like this: Cat Year Cat Type Budget 2019 A New 275 2020 B New 200 2021 C New 250 2019 A Ret 275 2020 B Ret 200 2021 C Ret 250 2019 A ...
Anonymous , Create a new column in Cat table
sumx(filter(Budget, Budget[Year] =Cat[Year] && Budget[cat] =Cat[Cat]),Budget[Budget])
Anonymous , Create a new column in Cat table
sumx(filter(Budget, Budget[Year] =Cat[Year] && Budget[cat] =Cat[Cat]),Budget[Budget])