Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
Solved! Go to 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
Hi @SarahAlsterspre ,
You could use SUMMARIZE function (DAX) - DAX | Microsoft Learn.
For example:
new table = summarize('your table',attendees,max([login]))
Best Regards,
Jay
@SarahAlsterspre , Refer if my blog on similar topic help
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Hey, thanks. I think this doesnt work because I dont have an ID like in your example.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |