DAX Formula to Calculate Last Activity?

[Anonymous]

Hi everyone-

I am looking to write a simple DAX formula that will only select the most recent date in the 'Expires' column. As you can see in the attached photo, the 'Expires' column logs the date and time whenever a user does any activity. How would I write a formula that just selects the most recent date? For the first user in the first five rows, I would just want the most recent date and time selected and to disregard anything before.

Also, disregard the fact that the user data is in JSON. I'm going to go through and clean that up so ultimately it will just have the userID in the column alongside the expires column. Thanks!

[StefanoGrimaldi]

if you doing this on DAX, theres a formula called: LastDate( ) this will always select for the DAX according how you use it as the last date on the selected column, if you want the table to be remake filtering out the other record, create a new talbe with "calculatedtable" and use the lastdate function on the calculated segment fo the new table to filter it out by the last date.

[Anonymous]

So ultimately what I'm trying to do is the following...

I have this table of user information, sorted by date of creation:

I'm trying to insert a column that shows last activity (which might be logging in, a new enrolllment, etc) which is tracked in this table:

They are connected with the UserId. What's the best way to go about this?

[StefanoGrimaldi]

them just use the LastDate( ) function a the modeling tab new column option, enter that dax and give the date column as parameter.