Calendar - end of quarter

[AnetaK]

Hello,

I've created a calendar table that ends today.

Calendar = CALENDAR(MIN(Task[ActivityDate]);TODAY())

Now I would like to change it, so that it ends with the end of current quarter, I need some future dates.

I don't have any existing column with dates, I am creating it, so I can not use ENDOFQUARTER as it requires a column.

What should I write in DAX?

[Greg_Deckler · Accepted solution]

Not entirely sure I understand your requirements, but if this needs to be dynamic per day, you might do something like:

Calendar = var MonthToday = MONTH(TODAY())
var YearToday = YEAR(TODAY())
var EndDate = IF(MonthToday<4,DATE(YearToday,3,31),IF(MonthToday<7,DATE(YearToday,6,30),IF(MonthToday<10,DATE(YearToday,9,30),DATE(YearToday,12,31))))
RETURN
CALENDAR(MIN(Task[ActivityDate]),EndDate)

[AnetaK]

Yes, it needs to be dynamic.

Thank you 🙂

[Greg_Deckler]

Cool, hope that formula works for you!

[AnetaK]

I've got an idea.

Calendar = CALENDAR(MIN(Task[ActivityDate]);TODAY()+92)

I've added a maximum number od days in a potential quarter.

That can help. But is it the proper solution?