Dynamically get last date of user or category

[Anonymous]

Hi.

So I have a table where every time a user logs into the app, the date (a timestamp) is recorded. A rough is example is this:

user_id	date_login
1	9/1/2021
1	9/1/2021
1	9/2/2021
1	9/3/2021
2	9/3/2021
2	9/4/2021
1	9/4/2021
1	9/4/2021
3	9/4/2021
3	9/5/2021
3	9/6/2021
1	9/6/2021
2	9/6/2021
2	9/7/2021
2	9/7/2021

What I want to achieve is have a calculated column or measure called last_login that updates to the last date a user opened the app. So from my example, user_id 1 will have the last_login as 9/6/2021 and if he opens the app again the next day, it updates to that date.

How do I best do that exactly? My thoughts went to a measure because calculated columns aren't dynamic, or am I off here?

Much appreciated.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could simply change the summarization type of date_login like this:

Or create measures:

Last login date1 = LASTDATE('Table'[date_login])

Last login date2 = MAXX(FILTER('Table','Table'[user_id]=MAX('Table'[user_id])),[date_login])

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous just add a simple measure like this and in the visual, drop user column and the measure:

Last Date = MAX ( Table[DateTime] )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Jos_Woolley]

Hi,

With a measure:

Last Login =
CALCULATE (
    MAX ( MyTable[date_login] ),
    ALLEXCEPT ( MyTable, MyTable[user_id] )
)

Regards

[Chrisor0414]

thanks!!! you really help me with this solution!