How to look up first discount in a related table.

[shophoney]

Hi,

I'm looking for a way to look up the first time an item was marked down.

I have a table with OH HISTORICAL, that has what our OH was each date historically. Then I want to look at what the discount was at that time in the related table.

The item will be discounted many times over the months.

I think the best solution is to do a DAX measure?

OH HISTORICAL

PRICEDISCOUNT