2 Replies Latest reply on Feb 9, 2018 10:40 AM by Ty Stackhouse

    Finding most recent Price

    Ty Stackhouse

      I have a data source that contains a list of all of my items and their price effective dates along with the prices. I would like to be able to find the most recent price based on the date. I have been trying to use a Max(Effective Date) calculation along with an LoD calculation but have not found a solution. Essentially I would like to be able to see one row of item numbers along with latest date and price associated with that date.

      I have attached a simplified workbook of the issue.