Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Find Most recent Record with Score

I have a table that lists the following. What i am wanting is the most recent date and score of each Case #.   Case# Admission Date Staff Member Score 1 1/1/2019 John 20 2 1/2/2019 ...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

You can try this measure and put it in filter:

 

Visual Control =

IF (

    SELECTEDVALUE ( Admissions[Admission Date] )

        = CALCULATE (

            MAX ( Admissions[Admission Date] ),

            FILTER (

                ALLSELECTED ( Admissions ),

                'Admissions'[Case#] IN FILTERS ( 'Admissions'[Case#] )

            )

        ),

    1,

    -1

)

 

 

You will get your hoped result like this:

 

Here is the demo , please try it:

PBIX 

 

Best Regards,

Yingjie Li

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello, when i am trying this it seems to be only returning the most recent record for one case # not all. 

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Take case in a table or matrix and this as second column and check

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I see now. Is there a way to SUM that total now? So it pulled both scores in for 35 however itsnt totaling the 2 most recent records i tried up. I appreciate all the help.