I found the below solution to work for my problem.
Latest = LASTNONBLANKVALUE('table'[column], SUM('table'[column]))