Custom column help

[Anonymous]

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

[Anonymous]

[v-deddai1-msft · Accepted solution]

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

[Anonymous]

Thanks a lot Dedmon. You rock!!