Need of last modified date for proposal id.

[ShaikAsif]

Hi

i had gots stucked up with mentiond issue.
Current Issue (not resolved )

 In above pic ,I had created a table , applied a slicer ,  selected Year 2021 ,by applying latest version filter i had achieved latest version proposal id upto here every thing is fine .
but for same i need another proposal of last modified date in same table .

Pls help me out to achieve..

.

Pls help me out ..
I had attched data file.

Version	Modified Date	Rating	Projection ID	Version	Previous_Rating
1	10-19-15	1	1000998	1	NULL
2	11-6-2015	2	1000998	2	1
8	2-4-2016	0	1000998	8	2
9	1-9-2020	1	1000998	9	0
20	1-24-2020	2	1000998	20	1
37	1-31-2020	3	1000998	37	2
38	1-31-2020	4	1000998	38	3
51	2-13-2020	6	1000998	51	4
56	6-30-2020	0	1000998	56	6
1	10-28-2016	1	1008491	1	NULL
2	9-6-2018	0	1008491	2	1
3	2-1-2021	1	1008491	3	0
9	2-1-2021	2	1008491	9	1
21	2-17-2021	0	1008491	21	2

Pls Help Me Out from this issue .
@amitchandak 

Regards 
Asif

[lbendlin]

The week number is missing from your sample data?