Last 2 weeks average/ employee

[homboy27]

Please see below data. I am calculating total sales divided by total hours in column I by employee. But I would like to calculate last 2 weeks average by employee in column J. 

So for example in Column J, I am calculating last 2 weeks average per employee. How would I do that in Power BI? How would I create column J? So for example for Mike it is calculating (10+10)/(25+25) and for Sonia it is calculating (10+15)/(25+25)

[parry2k]

@homboy27 change the DAX measure to this, and replace the value of __lastHowManyWeeks with 8 or whatever value you want, you can also make it dynamic:

Last x Weeks Average = 
VAR __LastHowManyWeeks = 2 --change this to number of weeks you are looking for.
VAR __WeekEnding = MAX ( 'Table'[Week Ending] )
VAR __WeekStart = __WeekEnding - ( ( __LastHowManyWeeks - 1 ) * 7 )
RETURN
AVERAGEX (
    FILTER ( 
        ALLSELECTED ( 'Table'[Week Ending] ),
        'Table'[Week Ending] >= __WeekStart && 'Table'[Week Ending] <= __WeekEnding
    ),
    [% Hours]
)

[homboy27]

Thank you, what do you mean by make it more dynamic?

[Syndicate_Admin]

@Syndicate_Admin see attached, tweak the solution as you see fit.

[homboy27]

thank you, what is the formuala if I wanted to do average of last 8 weeks?