Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |