Forum Discussion

Tob_P's avatar
Tob_P
Helper V
3 years ago
Solved

Date.AddYears based on interval in another column

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 orig...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi,

    Add a new column

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

     Stéphane

slorin's avatar
slorin
Super User
3 years ago

Hi,

Add a new column

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

 Stéphane