Getting the last available data in column

[krixtsup3r]

Hi everyone! Just wanna ask for help on creating a calculated column that would get the Last Project & date of a user in the table. Below how it looks:

The highlighted column is the one that I am trying to achieve. 

Ideally this should how my table would look like. 

Thank you!!

[amitchandak · Accepted solution]

@krixtsup3r , New columns

Last Proj =
var _date = maxx(filter(Table, [User_id] = earlier([user_id]) && [Date] < earlier([Date]) && [Project] <> EARLIER([Project])),[Date])
return
maxx(filter(Table, [User_id] = earlier([user_id]) && [Date] =_Date && [Project] <> EARLIER([Project])),[Project])

Last Date = maxx(filter(Table, [User_id] = earlier([user_id]) && [Date] < earlier([Date]) && [Project] <> EARLIER([Project])),[Date])

[krixtsup3r]

This works! Thank you!