Forum Discussion

dolevh's avatar
dolevh
Icon for Helper II rankHelper II
4 years ago
Solved

Dates Column with two different columns

Table Name: Projects   ProjectID       Active    StartDate    EndDate    New Column  1    1    1/1/2019    1/3/2021    1/3/2021 2    1    5/5/2019    (Blank)    5/5/2020 3 ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi dolevh ,

     

    Try this in a custom column:

    if [EndDate] = null and [Active] = 1 then Date.AddDays([StartDate], 365)
else [EndDate]

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi dolevh ,

 

Try this in a custom column:

if [EndDate] = null and [Active] = 1 then Date.AddDays([StartDate], 365)
else [EndDate]

 

Pete