cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Post Prodigy
Post Prodigy

Rolling 12 month measure to return result for certain period only

Hi Experts

 

Need to amend the following measure to return back a result where the term is 2 only. 

Rolling 6 =

VAR enddate = Llo_DIR_Data[Date]
VAR startdate =
EOMONTH ( enddate, -6 ) + 1
VAR result =
CALCULATE (
AVERAGEX (
DISTINCT ( Llo_DIR_Data[Date] ),
CALCULATE (
DIVIDE (
AVERAGE ( Llo_DIR_Data[Result] ),
AVERAGE ( Llo_DIR_Data[Apps in Month/Term] )
)
)
),
ALL ( Llo_DIR_Data ),
FILTER (
ALL ( Llo_DIR_Data[Date] ),
Llo_DIR_Data[Date] >= startdate
&& Llo_DIR_Data[Date] <= enddate
)
)
RETURN
result
 
Sample File
1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Route217 , means AVERAGE ( Llo_DIR_Data[Apps in Month/Term] ) =2 ? or Llo_DIR_Data[Apps in Month/Term]  =2

 

In first case what is the visual grouping



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@Route217 , means AVERAGE ( Llo_DIR_Data[Apps in Month/Term] ) =2 ? or Llo_DIR_Data[Apps in Month/Term]  =2

 

In first case what is the visual grouping



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Hi Amit - thank you,,,,excellent feedback - can you help with the following please. 
https://community.powerbi.com/t5/Desktop/Measure-error-on-rolling-12-month-calculated-column/m-p/199...

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors