Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.