Consecutive dates

[MonaKavi]

I am having an issue with my report, I have a table with a reference and start date (the earliest date is the start date and the latest date is the end date), Reference numbers are duplicated with different start and end dates, the report is working for those have a consecutive date but for those having the gap between start and end date is not working correctly) I want to show them in a different row if there is a gap between the start and end dates.

[Ashish_Mathur]

Hi,

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result clearly.

[MonaKavi]

Hi Ashish,

Data

Id	M ARMS Ref	Start D/T
562455	AO-PR-22-000871	11/10/2022 1:30:00 AM
562455	AO-PR-22-000871	13/10/2022 1:30:00 AM
548988	AO-PR-22-000841	10/12/2022 12:00:00 AM
548988	AO-PR-22-000841	10/12/2022 1:30:00 AM
548988	AO-PR-22-000841	11/12/2022 12:00:00 AM
548988	AO-PR-22-000841	12/12/2022 12:00:00 AM
542031	AO-PR-22-000813	24/10/2022 1:30:00 AM
542031	AO-PR-22-000813	25/10/2022 1:30:00 AM
542031	AO-PR-22-000813	26/10/2022 1:30:00 AM
542031	AO-PR-22-000813	27/10/2022 1:30:00 AM
542031	AO-PR-22-000813	28/10/2022 1:30:00 AM
541821	AO-PR-22-000812	31/08/2022 9:00:00 PM
467841	AO-PR-22-000219	07/11/2022 9:00:00 PM
467841	AO-PR-22-000219	08/11/2022 9:00:00 PM
467841	AO-PR-22-000219	09/11/2022 9:00:00 PM
467841	AO-PR-22-000219	10/11/2022 9:00:00 PM
455821	AO-PR-22-000181	10/12/2022 12:00:00 AM
455821	AO-PR-22-000181	10/12/2022 1:30:00 AM
455821	AO-PR-22-000181	11/12/2022 12:00:00 AM
455821	AO-PR-22-000181	12/12/2022 12:00:00 AM
429216	AO-PR-22-000132	26/11/2022 9:00:00 PM
429216	AO-PR-22-000132	27/11/2022 9:00:00 PM

Result

M ARMS Ref	Start Date	Start Time	Finish Date	Finish Time
AO-PR-22-000132	Sat, 26 Nov 22	21:00	Mon, 28 Nov 22	4:00
AO-PR-22-000181	Sat, 10 Dec 22	1:30	Mon, 12 Dec 22	3:00
AO-PR-22-000219 (4no)	Mon, 7 Nov 22	21:00	Fri, 11 Nov 22	4:00
AO-PR-22-000812	Wed, 31 Aug 22	21:00	Thu, 1 Sep 22	4:00
AO-PR-22-000813	Mon, 24 Oct 22	1:30	Fri, 28 Oct 22	4:00
AO-PR-22-000841	Sat, 10 Dec 22	1:30	Mon, 12 Dec 22	3:00
AO-PR-22-000871	Tue, 11 Oct 22	1:30	Tue, 11 Oct 22	4:00
AO-PR-22-000871	Thu, 13 Oct 22	1:30	Thu, 13 Oct 22	4:00

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  I have worked on the dates only.

Hope this helps.

[MonaKavi]

Hi Ashish,

Thank you s much.

[Ashish_Mathur]

You are welcome.