Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
6 years ago
Solved

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 (Cur...
Rolling Months
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
6 years ago

Hi Priya2007, 

 

Assume the [Month_Closed] in the table 'Work Delivery', you can create a measure like below: 

 

MeasureTotal=

VAR __table = SUMMARIZE('Work Delivery',[Month_Closed],"__value",[TTM_sales3])
RETURN
IF(HASONEVALUE('Work Delivery'[Month_Closed]),[TTM_sales3],SUMX(__table,[__value]))

 

Reference: 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

Best Regards,
Qiuyun Yu