Forum Discussion
Solved
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 ...
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 , 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
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