Blog Post

Power BI Community Blog
2 MIN READ

Power BI Continuous Streak - With One-Day Break

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago
Problem Description: There is a set within a group with start and end dates. When the end date and next start date have a gap of only one day, these dates need to be combined. Note: In HR, these ...
Updated 6 years ago
Version 3.0
Continuous streak
power bi
Power BI Desktop
amitchandak's avatar
Icon for Super User rankSuper User
Joined June 27, 2019
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
MCACT's avatar
MCACT
Regular Visitor
4 years ago

Power BI Continuous Streak - With No Break

 

Hi amitchandak 
Thank you for this amazing solution!

I am looking for a solution which takes records starting on the same day as previous record ended as well as next day (like your code solution solved). Also records with start and end dates within previous periods. I am trying to use your code, however I am not able to find where to change to get the result.

Would you be able to either help me or explain what each code section means?

This is the dataset:


Thank you!
Best regards!