topic Re: PowerBI - Formula Similar to Excel function where I can make column = specific value in DAX Commands and Tips

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

Anonymous — Thu, 02 Feb 2023 07:38:36 GMT

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

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

FreemanZ — Thu, 02 Feb 2023 08:18:53 GMT

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:

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

Anonymous — Thu, 02 Feb 2023 10:14:07 GMT

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