MAking a last day of month calendar

[quickbi]

Hi

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

[Anonymous]

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

[fahadqadir3]

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!! 

[rajendraongole1 · Accepted solution]

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!!