Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Keep only most recent date

Hi,

 

I have a list of patients and multiple columns indicating stop dates (for when they stopped trial medication). 

 

I only want two columns - participant ID and the most recent stop date, in the example below this would be 7/7/22 for patient 022-001.

 

 

Hoping someone can guide me 🙂

 

Best,

Soph

 

Need Help
Show and Tell
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Please try:

    Unpivot the other columns:

    Then apply the measure to table visual:

    Measure = MAX('Table'[Value])

    Final output:

    Best Regards,

    Jianbo Li

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

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    Please try:

    Unpivot the other columns:

    Then apply the measure to table visual:

    Measure = MAX('Table'[Value])

    Final output:

    Best Regards,

    Jianbo Li

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