Forum Discussion
Multiplication by filtering from different tables
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.
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
2 Replies
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-queryamitchandak 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
