PowerBI - Formula Similar to Excel function where I can make column = specific value

[Anonymous]

Hi

I have two tables in PowerBI with no relationship. One table with price and one table with additional fee.

I want to enter my own custom additional fee and I want it to pull through to the other table with whatever value I entered.

For example in my price table

100

150 

200

Now I want to say additional fee is 10. Then I want it to say 110 or if its 20 I want it to be 120. Similar to an excel equals formula

I cant link the 2 tables becauses theres no relationship. How do I go about making my value 110 if additional fee is 10

[FreemanZ]

hi @Anonymous 

LOOKUPVALUE could be handy to move data to unrelated tables.

not sure if i get your point, supposing you have two tables like:

Item	Price
A	100
B	150
C	200

Item	Fee
A	10
B	20
C	30

you may try to add a column in the price table with:

PriceWithFee = 
LOOKUPVALUE(
    FeeTable[Fee],
    FeeTable[Item],
    PriceTable[Item]
) 
+ [Price] 

it worked like:

[Anonymous]

Thanks for your response @FreemanZ 

Im speaking more of a scenarion where you enter a custom value. For example my company uses certain fixed fee for prices of your home

Table 1

In that table I have made a parameter where you can enter a custom value on a slicer and it will vlook up the fixed fee. So if you enter in 50 or 99  in the slicer, it will pull through a value of 5

Now I want to add in a custom value of additional fees. Whether you quote them 10 for moving fees or 50 for viewing fees doesnt matter, I want that extra value you enter to be added.

So for the other table I was going to use a generate series from 0 to 500. Then another parameter where I can enter a custom slicer

Similar to what you can do in Excel I want to add the 2 yellow columns to my main property table