Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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
Thank you so much for your solution, this is perfect!
a new column in table 1
funded value = [Price]*(1+ Max(Table2[Brokerage]) )
or
funded value = [Price]*(1+ Average(Table2[Brokerage]) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |