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 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]) )
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |