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 =
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:
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 🙂