Hi,
I have 2 tables that I would like to look up the MAX date of when an item was marked down based on a specific date.
The first table is OH HISTORICAL. I would like to add a column or measure to find out what the discount was on a SKU. That is on or before the DATE.
So fi the item was...