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
Anonymous
Not applicable

CALENDAR DAX: Starting on 01/01/2017 and finishing in the last day of previous month

Hi All, 

 

I have a calender table create based on DAX : 

CALENDAR = CALENDAR ("01/01/2017", today())

But what I would like is to have the "end date" of the calendar as the last day of previous month. Example: 

 

Today is 11/02/2019, on my calendar I'd like to have all dates between 01/01/2017 and 31/01/2019. I'd like to create this in a DAX to not amend the end of calendar each month. 

 

It's necessary, because my database is based on the previous month, and I dont want to give for the End user the option on my slicer of the current month as the data wont be there until the end of the month. 

 

I was trying to use DATEADD function but it had no sucess. 

 

Any clue how can I have in a DAX the return of the last day of previous month based on today to create my autocalendar ?

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @Anonymous

 

Try this:

 

CalendarTable =
CALENDAR ( "01/01/2017", EOMONTH ( TODAY (), -1 ) )

View solution in original post

1 REPLY 1
AlB
Super User
Super User

Hi @Anonymous

 

Try this:

 

CalendarTable =
CALENDAR ( "01/01/2017", EOMONTH ( TODAY (), -1 ) )

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.