Calendar Table invoke dates

[Raul09]

Hi everybody,

Well, we are starting a new year of reports! 

So, i was updating them then i realized all my MTD calculations stopped working, but only on my new data of 2018.

I think is because i have endofthemonth calculations for my MTD values and my calendar doesn't have those dates yet.

How can i invoke all 2018 in my calendar?

here is a screenshot of the calendar i'm using 

Thanks in advance.

[MarcelBeug]

Since you include a screen shot of a Power Query function: this formula creates a table with all dates for 2018:

= #table(type table[Date = date],List.Zip({List.Dates(#date(2018,1,1),365,#duration(1,0,0,0))}))

[Raul09]

Thanks for the reply @MarcelBeug

The real question is how can i edit my calendar to show all dates for 2018 starting in 2017.

[MarcelBeug]

The screen shot you posted, just included the general information of function List.Dates.

Without you posting your actual code, I won't be able to help you.