Forum Discussion
Solved
Adding a Column Filter to my current formula
Good morning all! I'm trying to modify my current formula to filter results by a column value if it matches another table's column. My example dataset is attached, but here's the goal: Table1 ...
keltzjd I used the file you sent earlier. Seems to work as expected. See Attached.
This is what my formula looks like with that addition but it's not working, where am I getting it wrong?
=SUM(
MMULT(
--(Table57[[PM]:[CM5]] = Table27[@[Name]:[Name]] ),
SEQUENCE( COLUMNS( Table57[[PM]:[CM5]] ), , 1,0) ) *
(Table57[Zone] = Table27[@[Zone]:[Zone]] ),
SEQUENCE( COLUMNS( Table57[Zone] ), , 1,0) ) *
Table57[[SUM]:[SUM]] *
( Table57[[Start Date]:[Start Date]] <=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
) *
( Table57[[End Date]:[End Date]] >=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
)
)
=SUM(
MMULT(
--(Table57[[PM]:[CM5]] = Table27[@[Name]:[Name]] ),
SEQUENCE( COLUMNS( Table57[[PM]:[CM5]] ), , 1,0) ) *
(Table57[Zone] = Table27[@[Zone]:[Zone]] ),
SEQUENCE( COLUMNS( Table57[Zone] ), , 1,0) ) *
Table57[[SUM]:[SUM]] *
( Table57[[Start Date]:[Start Date]] <=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
) *
( Table57[[End Date]:[End Date]] >=
DATEVALUE(Table27[[#Headers],[1/1/2022]] )
)
)
keltzjd I used the file you sent earlier. Seems to work as expected. See Attached.
- It did! Thank you so much!