Automatic Addition of Date

[iyogj]

Hi All, I am new to the community and this will be my first post of Many. I am new at power BI and have some basic idea only.

My Target at the moment is i have a timestamp column with date and time in it. is there an automatic way for it to create a new column for date with Additional Months (ie 3month). see below images.

Really apologies if the task is just simple enough, i am new at powerBI

Cheers,

Jaydee

[AlexisOlson]

Can you show what result you're expecting? It's not clear to me what this new column should look like.

[iyogj]

Hi Alexis,

Thank you for your response 

Results should be like this below table base with the table photo above "Start time / date" 

I am on the country with dd/mm/yy Format.

at the moment i am doing this on november month but i want it to be automatic everytime there is a new start time/date it will add additional 3months. 

hoping this is clear.

Cheers,

jaydee 

Start time / Date	Next Target time / date (Target results of New column)
15/11/2021 3:15:36am	15/02/2022 3:15:36am
14/11/2021 11:07:16pm	14/02/2022 11:07:16pm
14/11/2021 10:39:48pm	14/02/2022 10:39:48pm
14/11/202110:36:43pm	14/02/202210:36:43pm
14/11/202110:13:08pm	14/02/202210:13:08pm
14/11/2021 10:02:44pm	14/02/2022 10:02:44pm
14/11/2021 9:59:43pm	14/02/2022 9:59:43pm
4/11/2021	4/02/2022
and so On	and so On

[AlexisOlson · Accepted solution]

Thanks. That clears things up nicely.

Try adding a custom column using Date.AddMonths:

Date.AddMonths([#"Start time / Date"], 3)

[iyogj]

Works like magic, and as i taught it is a very simple trick. This Sort things out Really appreaciate it alexis.