DATESYTD and FIRSTDATE returns several seasons.

[RMM2C]

Hi! 

I'm working with seasonal periods, Starting the first of july. I need to dynamically return the first day of the current season, i.e first of july 2019. However when I use FIRSTDATE combined with DATESYTD, apparently returns the first dates of every single season on the calendar. Any sugestions?

CALCULATE(

SUM(Leads[Count]);

FILTER(Leads;Leads[Date]=

FIRSTDATE(

DATESYTD(Calendar[Date];"29-06")

Thanl you in advance.

[v-juanli-msft · Accepted solution]

Hi @RMM2C 

It seems your "season" is from 7/1 to 6/30 next year, like 2019/7/1~2020/6/30,

You want this formula to return 2019/7/1, not 2019/1/1,

If i understand you correctly, you can create a measure

Measure 2 = 
CALCULATE(COUNT('Table'[count]),FILTER('Table','Table'[date]=CALCULATE(FIRSTDATE(DATESYTD('date'[Date],"30-06")),YEAR('date'[Date])=YEAR(TODAY()))))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.