Rolling 12 month measure to return result for certain period only

[Anonymous]

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

https://www.dropbox.com/s/6uqpevfaqhxy0ye/sAMPLE.pbix?dl=0 

[amitchandak · Accepted solution]

@Anonymous , 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

[Anonymous]

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...