Forum Discussion
QTD Resets if value is 0
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 , 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])
2 Replies
komaldHelper I
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])Sorry for Such a Stupid Question.
