cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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.

1 ACCEPTED SOLUTION
Super User

@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]

2 REPLIES 2
Super User

@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]

Regular Visitor

@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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.