Forum Discussion
Automatic Addition of Date
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
Thanks. That clears things up nicely.
Try adding a custom column using Date.AddMonths:
Date.AddMonths([#"Start time / Date"], 3)
4 Replies
- AlexisOlson
Super User
Can you show what result you're expecting? It's not clear to me what this new column should look like.
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
Thanks. That clears things up nicely.
Try adding a custom column using Date.AddMonths:
Date.AddMonths([#"Start time / Date"], 3)