How to get the value from the most recent data for each individual

[mmadiganjr]

Trying to show the value (bodyweight) for the most recent date for each individual, and if they don't have a weight for the most recent date in the data it will still pull from the last time they weighed in. Recently created a measure that worked but wouldn't show the ones that didn't have a weight for the most recent date, & hitting a roadblock with my current measure.

[amitchandak · Accepted solution]

@mmadiganjr , refer if these blogs can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.