Forum Discussion
Custom column help
Hi community
I know this might be a silly question, but I am currently facing this problem I can not solve. So, basically, I have these 2 tables, and what I need is to show the sum of $ from the "money" table into the master table, but only when records match on Qtr, Region, and Review Type (highlighted in yellow):
| Master Table | Money Table | ||||||||
| Quarter | Region | Review Type | Total Money | Record ID | Quarter | Region | Review Type | Money | |
| 2020 Q1 | USA | G1 | ??? | 18467 | 2020 Q2 | Europe | G1 | $ 150 | |
| 2020 Q1 | USA | G2 | ??? | 18468 | 2020 Q1 | USA | G1 | $ 200 | |
| 2020 Q1 | USA | G3 | ??? | 18469 | 2020 Q1 | Asia | G4 | $ 350 | |
| 2020 Q1 | USA | G4 | ??? | 18470 | 2020 Q2 | Europe | G3 | $ 500 | |
| 18471 | 2020 Q1 | USA | G2 | $ - | |||||
| 18472 | 2020 Q2 | Asia | G1 | $ 120 | |||||
| 18473 | 2020 Q3 | Europe | G1 | $ 345 | |||||
| 18474 | 2020 Q3 | USA | G4 | $ - | |||||
| 18475 | 2020 Q1 | USA | G3 | $ 890 | |||||
| 18476 | 2020 Q1 | USA | G2 | $ 9,000 |
Hi Anonymous ,
Would you please refer to the following calculated column:
Total Money = CALCULATE(SUM(Money Table[Money]),FILTER(Money Table,Money Table[Quarter] = EARLIER(Master Table[Quarter])&& Money Table[Region] = EARLIER(Master Table[Region]) && Money Table[Review Type] = EARLIER(Master Table[Review Type])))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
3 Replies
Hi Anonymous ,
Would you please refer to the following calculated column:
Total Money = CALCULATE(SUM(Money Table[Money]),FILTER(Money Table,Money Table[Quarter] = EARLIER(Master Table[Quarter])&& Money Table[Region] = EARLIER(Master Table[Region]) && Money Table[Review Type] = EARLIER(Master Table[Review Type])))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai