Summarize and add column to another table

[Anonymous]

I have the first table like this

second table

I want the second table to be grouped by Customer and add it's paid_amount to first table as column

as below

Thank you

[Tahreem24]

@Anonymous ,

I replicated your sample at my side and got the expected result.  Attaching PBIX file for your reference.

[Tahreem24]

@Anonymous , If your both table connected properly with each other based on Customer Column so you dont need anything. Just drag all three columns in the single table visual.

You can see below two screen shots:

[amitchandak · Accepted solution]

@Anonymous , A new column in first table

if they are realted ,

sumx(relatedtable(second), second[paid amount])

if not

sumx(filter(second, first[cutomer] =second[customer]), second[paid amount])

refer: https://www.youtube.com/watch?v=czNHt7UXIe8

Power query merge can also help : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

@amitchandak 

Thank you for reply.

sumx(filter(second, first[cutomer] =second[customer]), second[paid amount]) I have used this one since tables are not related. Is that possible to add another date filter to second table like ,

second[Date] = eomonth(today(),-1)+1 ?