Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
GMB71
New Member

Custom YTD measure working on desktop but not online when published.

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:

ytd deskptop.PNG

 

But on the online version it looks like this: 

ytd online.PNG

 

Any thoughts on a solution appreciated. 

3 REPLIES 3
some_bih
Super User
Super User

Hi @GMB71 please check Calendar / Date table on both instance (expected continues dates on both inst.).





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






some_bih
Super User
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?





Did I answer your question? Mark my post as a solution!

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. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.