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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.