Rolling month
Hi , I am using below formula to count Calculated_required_dates by 12 month rolling TTM_sales3 = VAR Currentdate = EOMONTH(Max ('Date'[CLOSED_DATE]),0) var PreviousDate = EDATE ( EOMONTH (Currentdate, -1 ), -12 ) +1 VAR Result = CALCULATE (count('Work Delivery'[Calculated_REQUIRED_DATE]), Filter ('Work Delivery',MAX('Work Delivery'[CLOSED_DATE])>=PREVIOUSDATE && MAX('Work Delivery'[CLOSED_DATE])<= CURRENTDATE)) RETURN Result I am getting the exact result but total is missing.
