Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Calendar Table invoke dates

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.

Community Champion
Community Champion

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))}))
Specializing in Power Query Formula Language (M)


Thanks for the reply @MarcelBeug


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


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.

Specializing in Power Query Formula Language (M)

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors