topic MAking a last day of month calendar in DAX Commands and Tips

MAking a last day of month calendar

quickbi — Wed, 26 Jun 2024 07:31:00 GMT

I'm creating a calendar with this function:

Calendar =
VAR StartDate = MIN('orders_time'[created_at])
VAR EndDate = ENDOFMONTH(MAX('orders_time'[created_at]))
RETURN
CALENDAR(StartDate, EndDate)

but did not work, any idea how to setup the last day of the calendar has to be the last day of the month?

Thanks guys

Re: MAking a last day of month calendar

rajendraongole1 — Wed, 26 Jun 2024 07:41:41 GMT

Hi quickbi - can you try below calendar table.

Calendar =

VAR StartDate = MIN('Date'[Date])

VAR EndDate = EOMONTH(MAX('Date'[Date]), 0)

RETURN

CALENDAR(StartDate, EndDate)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: MAking a last day of month calendar

fahadqadir3 — Wed, 26 Jun 2024 07:45:50 GMT

Calendar =
VAR StartDate = MIN('orders_time'[created_at])
VAR EndDate = EOMONTH(MAX('orders_time'[created_at]), 0)
RETURN
CALENDAR(StartDate, EndDate)

quickbi Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: MAking a last day of month calendar

Anonymous — Fri, 28 Jun 2024 09:21:40 GMT

Hi quickbi ,

Based on the description, rajendraongole1 the response provides the solution. It should be helpful to you.

If you have solved the problem, please please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu