How to multiply each row value by a fixed value from another table?

[edwardroa]

Hi all,

Thanks for looking into my query.

I would like to add a column to my data by which it multiplies a row in my table (Price) by a fixed value from another table (Brokerage). I would prefer to do this in Power Query as opposed to a measure. The 2 tables are shown below as an example:

The formula is as below:

Thank you so much for your help!

Kind regards,

Edward

[MahyarTF · Accepted solution]

Hi,

1- In Power Query, in the main table, click on the 'Custom Column' in the 'Add Column' tab. 

2- Put the table name in the Box : (for me was 'Sheet139') :

3- Expand the new column and click Ok 

4- then Create new column and do as below :

You could change the data type to currency and use it in your visuals

Appreciate your Kudos

[edwardroa]

Thank you so much for your solution, this is perfect!

[amitchandak]

@edwardroa ,

a new column in table 1

funded value = [Price]*(1+ Max(Table2[Brokerage]) )

or

funded value = [Price]*(1+ Average(Table2[Brokerage]) )