Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have a custom year to date measure that works for our year that runs August to July with the measure below:
Count of StudentID YTD =
IF(
ISFILTERED('EngagementData'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
TOTALYTD(
COUNTA('EngagementData'[StudentID]),
'EngagementData'[Date].[Date],
"01/08"
)
)It works great on desktop as so:
But on the online version it looks like this:
Any thoughts on a solution appreciated.
Hi @GMB71 please check Calendar / Date table on both instance (expected continues dates on both inst.).
Proud to be a Super User!
Hi @GMB71 YTD measure calculating from 1st January "again", it is expected to have "reset" from January.
Did you check if something is filtered in both version?
Proud to be a Super User!
Filters are identical on both instances. The difference seems to be that the desktop version pays attention to the custom start of the year as speicified in the DAX statement but the online version doesn't for some reason.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 14 | |
| 12 | |
| 10 |