Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
noodles281
Frequent Visitor

Calculated Column required to evaluate maximum number of consecutive events attended

I'm going around in circles with this now. So posting on here to see if a fresh pair of eyes will solve it. Thank you so much for your attention and participation.

 

Events take place, and people attend these. I have attended each event and would like to know how many consecutive events any participant has had and who is on the longest current streak (so involving the most recent event). All my thoughts suggest this should be a calculated column either in the EVENTS table or the PARTICIPANTS table. Still, I can't work out a way to increment the count, so the consecutive attendances are counted properly.

In my mind, the result should be in one of these two formats.

 

EVENTS

EventNumberPersonIDConsecutiveCount
1661
2662
3663
566 
666 
766 
8661
10662
1266 
1366 
14661
16662
17663
2066 
2166 
1481
248 
3481
448 
748 
8481
9482
10483
11484
12485
1448 
1548 
1648 
1748 

 

or

 

PARTICIPANTS

PersonID

Consecutive Count

663
485

 

Download the EVENTS table ( contains EventNumbers and PersonID)

https://geordieintelligence-my.sharepoint.com/:f:/g/personal/ross_geordieconsulting_co_uk/EiPMJAmWVP... 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Picture2.png

 

Link to the PBIX file 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Picture2.png

 

Link to the PBIX file 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


Thank you, a couple of tweaks and it's now in as a calculated column so I can more easily use it for the metrics, people want to quickly see who's currently holding the consecutive attendance record etc... Massive help and glad to see I wasn't a too far off either 👍

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors