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
if you want to use lookupvalue,you can try this.
Column = LOOKUPVALUE(budget[Budget],budget[Cat],'cat'[Cat],budget[Year],cat[Year])