QTD Resets if value is 0

[Anonymous_KH]

Hello,

I am pretty new to PowerBI and trying to create Quater to Date Measure. Have created QTD calculation for measures based On Revenue , which works fine as long as value is contious . But doesn't work , if value is 0 , it automatically resets to 0, Is there a way to fix this .

[Anonymous_KH]

Sorry for Such a Stupid Question.

[komald · Accepted solution]

@Anonymous_KH , You are using totalqtd dax it will provide running total for quarter only if your quarter get chages it will start from begining for quarter.

 try this, i hope it will work for you

YTD= Totalytd([total revenue],sales[date].[date])