Forum Discussion
Getting the last available data in column
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!!
Anonymous , 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])
2 Replies
- amitchandak
Super User
Anonymous , 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])