Return Latest Price for Multiple Lines

Hi, Anonymous 

Based on your description, I created data to reproduce your scenario.

InventorySitesOn-Hand:

InventItemPrices:

There is many-to-one relationship between 'InventItemPrices' and 'InventorySitesOn-Hand' tables.

You may create a calculated column in InventorySitesOn-Hand as below.

Result = 
var _itemnum = 'InventorySitesOn-Hand'[ItemNumber]
var _latestdatetime = 
CALCULATE(
    MAX(InventItemPrices[PriceCreatedDateTime]),
    FILTER(
        ALL(InventItemPrices),
        InventItemPrices[ItemNumber] = _itemnum
    )
)
var _price = 
CALCULATE(
    SUM(InventItemPrices[Price]),
    FILTER(
        ALL(InventItemPrices),
        InventItemPrices[PriceCreatedDateTime] = _latestdatetime&&
        InventItemPrices[ItemNumber] = _itemnum
    )
)
return
[OnHandQuantity]*_price

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.