How to add next months to Current Date

[yodha]

Hi,

In my data i am generating DATE column using "DateTime.LocalNow()"  function. I would like to add future months (Jul,Aug,Sep...Dec) to this DATE column. Any help on this?

Thanks in Advance 

[dax · Accepted solution]

Hi @yodha , 

I am not sure your detailed requirement, did you want to create a date list from today to feature? If so, you could try below M code

let
    Source = List.Dates(DateTime.Date(DateTime.LocalNow()), 100, #duration(1,0,0,0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"

If not, please correct me and inform your expected output.

Best Regards,
Zoe Zhi

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

[Tahreem24]

If you are using M code so use the below :

Date.AddMonths(#date(2020, 1, 1), 12)

   Use the below link:

https://docs.microsoft.com/en-us/powerquery-m/date-addmonths

[Tahreem24]

You can also create a calendar dimension using below Dax Table:

Calendar Dimension= Calendar ( Date(  2020,1,1), Date (2020,12,31))

So it will calendar table from 1st  Jan to 31st Dec 2020