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
