Forum Discussion
Trailing Week Average
Hi everyone, I have just started using Power BI and DAX however I have been struggling with a trailing average measure. My data is sorted like the example data below. The problem I am having...
Greg_Deckler
Community Champion
Community ChampionAnonymous You will need to do something like:
Measure =
VAR __CurrentWeek = WEEKNUM(TODAY())
VAR __StartWeek = __CurrentWeek - 13
RETURN
AVERAGEX(FILTER('Table', [Week No] >= __StartWeek && [Week No] < __CurrentWeek),[Salesvalue])