Calculate a future date from a date column

[Elisa112]

Hi Experts

I am trying to calculate a future date (3 months) from the last appointment date for our users.  This will allow us to cancel membership 3 months from the last appointment.  My summary table data looks like this

I now need a column which provides the date 3 months from the last attended appointment.  I have tried the dateadd function but get an error.

thank  you in advance

[v-weiyan1-msft · Accepted solution]

Hi @Elisa112 ,

@amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.

FutureDate = 
EDATE ( 'Table'[Last appointment date], 3 )

Result is as below.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Elisa112 , Create a new column

New Date = date(year([Date]), month([Date])+3, day([Date]) )

[Elisa112]

@amitchandak thanks for your help as well. I am going to look at your solution to understand this method.