need help

[Anonymous]

Want to search for price of  item,if the item is not found in the list, power bi to calculate its price and display it, which price will be calculated as follow

price = standard cost * group factor

where standard cost is available in a table containing all the standard cost of items

group factor is also in the table

in excel I was doing it by vlookup the standard cost and group factor from two columns

thanks

[lucadelicio]

Hi can you share:
 - the pbix
 - excel example data
 - the result that you want