cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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
1 ACCEPTED SOLUTION
Community Support

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 3
Anonymous
Not applicable

Community Support

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
Not applicable

Thanks a lot Dedmon. You rock!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors