Grouping Dates by Object

[amirabedhiafi]

I’m working on an object hire report that needs to group objects with consecutive borrowed on dates into a single row in a table visual. The columns are;

Object No
Borrowed Date
Returned Date

Using SWITCH to calculate the Start Date and End Date dynamically based on a date slicer. What I need to do now is combine those two into a single line when the borrowed date(s) are consecutive days.

In this screen shot, the last two lines need to be combined into a single row with the start date being 18/01/2021 and the end date being 19/01/2021. The dates in the slicer are 01/01/2021 to 30/01/2021 which is why the first lines start and end dates are blank.

I’ve uploaded a cleaned copy of the report.

[amitchandak · Accepted solution]

@amirabedhiafi , Not very clear, refer if my blog can help on this

https://community.powerbi.com/t5/Community-Blog/Power-BI-Continuous-Streak-With-One-Day-Break/ba-p/1...