Making an end date column from a date list

Question

Hi community,&nbsp;&nbsp;have this huge one to fix and it screws my whole model.I have this source on excel where the dates associated with the date list associated to each "servizio", service, is basically a date range. E.G.&nbsp;A1HTLFORTI service S5 in first row starts 11/06/2021 ends the 06/08/2021. So basically what i need is the end date that terminates one day before the next start date.&nbsp;&nbsp;Servizio&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Inizio&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Tipo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Nome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RateA1HTLFORTI12/06/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI12/06/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI07/08/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI07/08/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI23/08/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI23/08/2021S5STTOWTOWER SUITE DOUBLE590A1HTLFORTI26/05/2021S5STTOWTOWER SUITE DOUBLE519A1HTLFORTI26/05/2021S5STTOWTOWER SUITE DOUBLE519A1HTLFORTI29/08/2021S5STTOWTOWER SUITE DOUBLE519A1HTLFORTI29/08/2021S5STTOWTOWER SUITE DOUBLE519A1CASMONTE10/07/2021S2PRINCPRINCE'S SUITE500A1CASMONTE10/07/2021S2PRINCPRINCE'S SUITE500A1HTLFORTI12/06/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI12/06/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI07/08/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI07/08/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI23/08/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI23/08/2021S4STNAPNAPOLEONE SUITE DOUBLE460A1HTLFORTI17/05/2021S5STTOWTOWER SUITE DOUBLE449A1HTLFORTI17/05/2021S5STTOWTOWER SUITE DOUBLE449A1HTLFORTI27/09/2021S5STTOWTOWER SUITE DOUBLE449A1HTLFORTI27/09/2021S5STTOWTOWER SUITE DOUBLE449A1HTLFORTI30/12/2021S5STTOWTOWER SUITE DOUBLE449A1HTLFORTI30/12/2021S5STTOWTOWER SUITE DOUBLE449A1RESFILO17/07/2021S1GRSUIGRAND SUITE419A1RESFILO17/07/2021S1GRSUIGRAND SUITE419A1RESFILO17/07/2021S5SUITESUITE FILODIVINO419A1RESFILO17/07/2021S5SUITESUITE FILODIVINO419A1HTLFORTI12/06/2021S3STJUNJUNIOR SUITE DOUBLE410A1HTLFORTI12/06/2021S3STJUNJUNIOR SUITE DOUBLE410A1HTLFORTI07/08/2021S3STJUNJUNIOR SUITE DOUBLE410A1HTLFORTI07/08/2021S3STJUNJUNIOR SUITE DOUBLE410A1HTLFORTI23/08/2021S3STJUNJUNIOR SUITE DOUBLE410A1HTLFORTI23/08/2021S3STJUNJUNIOR SUITE DOUBLE410&nbsp;&nbsp;as i said i tried by indexing rows and by expanding a date.list, but since services are randomly sorted the outcome was poor.&nbsp;Is there any way to fix this?&nbsp;thanksAlberto&nbsp;

amitchandak · Accepted Answer

abartozzi , Try a new column like 
minx(filter(Table,[Id] = earlier([Id]) &amp;&amp; [Inizio] &gt; earlier([Inizio])), [Inizio]) -1

Forum Discussion

Making an end date column from a date list

1 Reply

Related content

Help Making Column Headers (Dates) Dynamic in PBIX

Find Most Recent Date Relative to another Date Column in Power Query

Progressive Date Columns

How to make warehouse queries faster and make reports upto date without getting failed

Make Parameter effective using calculated column

A1HTLFORTI	12/06/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	12/06/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	07/08/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	07/08/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	23/08/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	23/08/2021	S5	STTOW	TOWER SUITE DOUBLE	590
A1HTLFORTI	26/05/2021	S5	STTOW	TOWER SUITE DOUBLE	519
A1HTLFORTI	26/05/2021	S5	STTOW	TOWER SUITE DOUBLE	519
A1HTLFORTI	29/08/2021	S5	STTOW	TOWER SUITE DOUBLE	519
A1HTLFORTI	29/08/2021	S5	STTOW	TOWER SUITE DOUBLE	519
A1CASMONTE	10/07/2021	S2	PRINC	PRINCE'S SUITE	500
A1CASMONTE	10/07/2021	S2	PRINC	PRINCE'S SUITE	500
A1HTLFORTI	12/06/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	12/06/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	07/08/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	07/08/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	23/08/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	23/08/2021	S4	STNAP	NAPOLEONE SUITE DOUBLE	460
A1HTLFORTI	17/05/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1HTLFORTI	17/05/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1HTLFORTI	27/09/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1HTLFORTI	27/09/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1HTLFORTI	30/12/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1HTLFORTI	30/12/2021	S5	STTOW	TOWER SUITE DOUBLE	449
A1RESFILO	17/07/2021	S1	GRSUI	GRAND SUITE	419
A1RESFILO	17/07/2021	S1	GRSUI	GRAND SUITE	419
A1RESFILO	17/07/2021	S5	SUITE	SUITE FILODIVINO	419
A1RESFILO	17/07/2021	S5	SUITE	SUITE FILODIVINO	419
A1HTLFORTI	12/06/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410
A1HTLFORTI	12/06/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410
A1HTLFORTI	07/08/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410
A1HTLFORTI	07/08/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410
A1HTLFORTI	23/08/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410
A1HTLFORTI	23/08/2021	S3	STJUN	JUNIOR SUITE DOUBLE	410