How Create List.Dates(#date(2020, 01, 01), to firs day from last month

[lboldrino]

I try to create this Date-Table...

it musst to able add every new month, the last month to date table.

firstOfPeriode

01.01.2020
01.02.2020
01.03.2020
01.04.2020
01.05.2020
01.06.2020
01.07.2020
01.08.2020

=List.Dates(#date(2020, 01, 01), (?????))

Thnx or any Idea!

[amitchandak]

@lboldrino ,

something like this

List.Dates(#date(2020, 01, 01), Duration.Days(Date.StartOfMonth(DateTime.LocalNow()) - #date(2020, 01, 01)), #duration(1, 0, 0, 0))

[lboldrino]

😞

[lboldrino · Accepted solution]

works perfect!

Thanx!

= List.Dates(#date(2020, 01, 01), Duration.Days(Duration.From(DateTime.Date(Date.StartOfMonth(DateTime.LocalNow())) - #date(2020, 01, 01))), #duration(1, 0, 0, 0))

[Greg_Deckler]

@lboldrino So you want to get the Date.Month of your max value, subtract that from the Date.Month of your min value and use that as your 2nd parameter, with a third parameter of 1?

Is that correct?

[lboldrino]

no. i want to create a simple datet table... start. 01.01.2020 to first day of ast month.

[Pragati11]

Hi @lboldrino ,

Refer following article on creating a Date table in Power BI Query Editor section:

https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query

Thanks,

Pragati