Forum Discussion
edwardroa
Helper I
Helper IHow to multiply each row value by a fixed value from another table?
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 pre...
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
MahyarTF
Memorable Member
Memorable MemberHi,
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
edwardroaHelper I
Helper IThank you so much for your solution, this is perfect!