calculating Last Login

[SarahAlsterspre]

Hi, 

I have webinar attendees for various webinars. And I would like to have a new table with each attendee and his last attendance, because they mostly attended multiple times. What I did, was the following: 

Data - Attendees =

ADDCOLUMNS (

    DISTINCT ( 'Data - Webinar Attendees'[E-Mail] ),

     "Last Login", calculate(LASTDATE('Data - Webinar Attendees'[Login].[Date])))

What then happens is that I get a table with two columns:

Attendees	Last Login
Dan	31.12.2022
...	31.12.2022
...	31.12.2022
...	31.12.2022

I dont know which DAX-Formula to use?! The "lastdate" isnt working obviously because "31.12.2022" is in the future which is not possible and which is no data in my table. the last date in my data is "3.11.2022". I also tried "max" and "maxa". 

I am looking forward to your help 🙂

Greets

[v-jayw-msft · Accepted solution]

Hi @SarahAlsterspre ,

You could use SUMMARIZE function (DAX) - DAX | Microsoft Learn.

For example:

new table = summarize('your table',attendees,max([login]))

Best Regards,

Jay

[amitchandak]

@SarahAlsterspre , Refer if my blog on similar topic help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[SarahAlsterspre]

Hey, thanks. I think this doesnt work because I dont have an ID like in your example.