Forum Discussion
Determine First/Last In Period
Hi v-xicai ,
I thought this was quite clear in the original message but please see a mock-up table below based on the scenario I've described above focusing specifcally on the John Doe record:
| Age | Current Result | Desired Result |
| 39 | 1 | |
| 40 | 1 | 1 |
| Total | 1 | 1 |
Currently I see a result for John Doe under 39 and 40 when I only want to see the result of his latest record which makes him 40; records are ordered based on the JobIssue date in the table in the original post.
Using the measures etc that I currently have I'm looking at all jobs whereas I need the measure to dynamically pick the earliest/latest in the period; as I mentioned, it's most likely that I'd use latest to distinguish the two in the business application.
Just bumping this as still struggling with getting this one to work; as in the original question I can pick out all people in a specific period using a slowly changing dimension but am struggling to pick out a specific record of theirs to avoid duplicate counts when I start to break the data down into categories.