Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.