I'm trying to build a report that shows values relative to the current date for a variety of properties in a table.
Pre Lease %
Example: If I set the Date Slicer to 3 months ago, I want it to show me the data that was entered nearest to February 6th (3 months ago). However, it seems I only have the ability to pull the average, sum, etc of the values from that range. These values are entered in to our database weekly, so if I set it to "Do Not Summarize", I get a ton of Site A, Site B, and Site C lines, each with their own entry.
Thank you for your help and I'm happy to provide more context if necessary!
Below is the sample data, and I am trying to filter based upon the Modified Date. There are several entries for each property throughout time, and when we filter via the slicer, we want to be able to capture a single piece of data that is closest to the relative date selected and display it in a table or matrix.