Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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()))))
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()))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |