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 marked down on the 9/8/19, 12/6/19, 6/7/20, 9/15/20 and 12/26/20 I would like to know the discount was on 9/15/20 as that is on or before "DATE".
I have the 2 tables related to a main table that has the SKU# listed only once. And in table OH HISTORY the sku# will be listed at many locations and on many count dates. In table DISCOUNT the same sku could be list 20-30 times as it would be discounted throughout the season.
Discount table
I'm not sure if I need to add a column RELATED or RELATEDTABLE? Or if the most efficient way is a MEASURE.
All of this DATA will be pulled into Excel as a pivot table.
Thanks
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 marked down on the 9/8/19, 12/6/19, 6/7/20, 9/15/20 and 12/26/20 I would like to know the discount was on 9/15/20 as that is on or before "DATE".
I have the 2 tables related to a main table that has the SKU# listed only once. And in table OH HISTORY the sku# will be listed at many locations and on many count dates. In table DISCOUNT the same sku could be list 20-30 times as it would be discounted throughout the season.
Discount table
I'm not sure if I need to add a column RELATED or RELATEDTABLE? Or if the most efficient way is a MEASURE.
All of this DATA will be pulled into Excel as a pivot table.
Thanks
