PowerQuery Calendar Table

[gavs73]

Hi

I have an Automated Caldendar table, using the M Code below, is there a way to change it so that it goes up in increments of 1 Month rather than by Day ?

= List.Dates(Source, Number.From(DateTime.LocalNow())-Number.From(Source),#duration(1,0,0,0))

Thanks for your help.

Gav

 

[Norie]

Gav

Do you only want to display the month and year?

Perhaps List.Transform with Date.ToText might help.

= List.Transform(List.Dates(Source, Number.From(DateTime.LocalNow())-Number.From(Source),#duration(30,0,0,0)), each Date.ToText(_, "MMMM-yyyy))

 

[gavs73]

Gav

Do you only want to display the month and year?

Perhaps List.Transform with Date.ToText might help.

= List.Transform(List.Dates(Source, Number.From(DateTime.LocalNow())-Number.From(Source),#duration(30,0,0,0)), each Date.ToText(_, "MMMM-yyyy))

Hi thanks for your reply, instead of the returning individual days between my start date 01/01/2021 and Today, I just need the Month, so as at Today I'd only have 3 rows for January, February, March. Instead of 60+ rows that i currently have for days.

 

[Norie]

What I posted will only return months - note the change in #duration.

If all you want is the month name change "MMMM yyyy" to "MMMM".