Forum Discussion
Dynamically Retrieve Last Observation per ID
Hi All, I'm trying to create a table that has the last observation for each ID in my data, relative to the current value in a date slicer. Sample data below, thanks for your help! I...
Ashish_Mathur wrote:Hi,
What result are you expecting?
As an example, if I were to have the date slicer set to 5/15/2018, I would expect the data in my original post to look like this:
| ID | Type | Date | Other | Vars |
| 23 | UPDATED | 12/28/2017 9:23:01 PM | Fun | Data |
| 32 | UPDATED | 12/31/2017 9:10:58 PM | Fun | Data |
| 217 | UPDATED | 12/28/2017 9:23:01 PM | Fun | Data |
| 227 | DELIVERED | 4/6/2018 2:03:02 PM | Fun | Data |
