Forum Discussion
Solved
Sumif based on another table
Hello! I am trying to create a calculated column that will sum the matching data from another table. Here's an overview: Table 1 looks like this: Name Value Jones 1 5 Jones 2 8 X...
You can use this calculated column
Column = SUM ( Table1[Value] ), FILTER ( Table1, SEARCH ( [Last], Table1[Name], 1, 0 ) > 0 ) )
You can use this calculated column
Column =
SUM ( Table1[Value] ),
FILTER ( Table1, SEARCH ( [Last], Table1[Name], 1, 0 ) > 0 )
)
This worked perfectly! Thank you!
