Multiplication by filtering from different tables

[Tunahan]

Hi, I have a problem I cannot solve. I want to multiply two tables and filter the rows. I have 2 tables. One of them includes coefficients, and the other one includes costs. I want to multiply costs and the relating coefficients. For example:

Coefficients:

AAA	x1	0,6
AAA	x2	0,4
BBB	x2	0,3
BBB	y1	0,7

Costs:

AAA	January 21	5000
AAA	February 21	3000
BBB	January 21	4000

At the end(What I want):

x1	January 21	AAA	=5000*0,6
x2	January 21	AAA	=5000*0,4
x1	February 21	AAA	=3000*0,6
x2	February 21	AAA	=3000*0,4
x2	January 21	BBB	=4000*0,3
y1	January 21	BBB	=4000*0,7

I tried so many formulate like Summarizecolums, calculate, summarize, filter, etc. But, I couldn't get a solution. Thanx for any help.

[amitchandak · Accepted solution]

@Tunahan , Best is merge in power query, then both will be in same table

and you can create a new column

= Coefficients[Col3]*costs[Col3]

merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Tunahan]

@amitchandak I tried this but I got a solution like this:

x1	AAA	0,6	table
x2	AAA	0,4	table

The tables in the cells include:

AAA	January 21	5000
AAA	February 21	3000

Now, I'm searching the split that table in the cells to rows.

Edit: I saw the table expand button, thanx @amitchandak