Column value based on Latest Date and category filter

[santhiya]

Hi Community!!!,
I am having table "Student" as below

id name

1 sam

2 kind

and "Student Activity" as below

student_id status date reported_to

1 started 12/03/2023 bingston

1 break 14/03/2023 rithu

1 started 15/03/2023 rithivi

1 finished 17/03/2023 kiwn

2 started 19/04/2023 ram

2 break 20/04/2023 dithirn

2 started 21/04/2023 rahul
2 break 24/04/2023 rahul
2 finished 25/04/2023 nivin

Student table has relationship with Student activity with id and student_id respectively

I need to find the "reported to "column value for each student for the latest date in status with started or break as status and add it as a calculated column(latest_reported_person) to Student Table

for example student id 1 has latest date 15/03/2023 in started and the reported_to column value is rithivi
similarly student id 2 has latest date 24/03/2023 in break status and the reported_to column value is rahul

How to achieve this with DAX?

[santhiya]

@amitchandak Thanks , But it is not my expected output

[amitchandak]

@santhiya , refer if the approch in the blog 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...