Forum Discussion
Anonymous_KH
4 years agoFrequent Visitor
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 doe...
- 4 years ago
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])
komald
Helper I
4 years agoAnonymous_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])