Rolling month

Question

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

v-qiuyu-msft · Accepted Answer

Hi&nbsp;Priya2007,&nbsp;
&nbsp;
Assume the&nbsp;[Month_Closed] in the table&nbsp;'Work Delivery', you can create a measure like below:&nbsp;
&nbsp;
MeasureTotal=
VAR __table = SUMMARIZE('Work Delivery',[Month_Closed],"__value",[TTM_sales3])RETURNIF(HASONEVALUE('Work Delivery'[Month_Closed]),[TTM_sales3],SUMX(__table,[__value]))
&nbsp;
Reference:&nbsp;
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

Forum Discussion

Rolling month

1 Reply

Related content

12-month rolling cumulative

Rolling accumulation

Rolling accumulation

Dax Time Intelligence Functions Weird behavior - 13 Month Rolling Calc

Rolling 12 Month calculation