Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Raul09
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 

 

Untitled.png

 

Thanks in advance.

3 REPLIES 3
MarcelBeug
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.