Forum Discussion

BM4291's avatar
BM4291
Resolver I
7 years ago

Determine First/Last In Period

Hi,   Having some difficulty with a measure; I've previously had some help with setting up a slowly changing dimension measure which allows me to see whether people are on record during a period of...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi BM4291 ,

 

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy

  • BM4291's avatar
    BM4291
    Resolver I
    7 years ago

    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:

     

    AgeCurrent ResultDesired Result
    391 
    4011
    Total11

     

    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.

    • BM4291's avatar
      BM4291
      Resolver I
      7 years ago

      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.