change calendar table to include end dates

[Elisa112]

Hi Experts

I have created my calendar table using list function 

= List.Dates(#date(2023,1,1),365,#duration(1,0,0,0))

However my visuals only include data for 2023 and we need to continue to show users into 2024 and potentially beyond. Do I need to just add an end date or is there something else I am missing?

as you can see we are only getting data from sept 2023 and nothing for 2024 (217)

Thanks in advance

[Elisa112]

@kpost

Thank you

[kpost · Accepted solution]

It looks like here you asked for a list of dates starting on Jan 1, 2023, and extending 365 days into the future with increments of 1 day:

List.Dates(#date(2023,1,1),365,#duration(1,0,0,0))

change that to 

List.Dates(#date(2023,1,1),730,#duration(1,0,0,0))

And it will list all dates through the end of 2024.

///Mediocre Power BI Advice, but it's free///