cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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.Total is missing
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Rolling month

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator

## Re: Rolling month

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors