I am using a RELATED function, working in Power BI and Power Pivot, and assigning values from other tables. It works similarly to VLOOKUP in Excel and LOOKUPVALUE in DAX.

I am using the Table of sales of ITEMS and at the same time using the table of prices of these items. What do I do to get the price of these items and on every entry of the item?

Thanks