Date.AddYears based on interval in another column

[Tob_P]

Hi,

Related this Solved: Re: DATEADD issue - Microsoft Fabric Community

I'm looking for some help on a custom column in query editor. I would like to calculate a future date, based on my original date column, X number of years in the future based in an interval column. Example data and expected format below. If 0 is in the interval column, then there should be no future date output

Start Date	Interval	Expected End Date
01/05/2023	0
25/06/2022	4	25/06/2026
04/10/2022	2	04/10/2024
19/06/2021	1	19/02/2022
15/10/2020	4	15/10/2024
04/07/2022	5	04/07/2027
21/07/2021	0

[Tob_P]

@slorin 

Much appreciated!

[slorin · Accepted solution]

Hi,

Add a new column

if [Interval]>0 then Date.AddYears([Start Date],[Interval]) else null

 Stéphane