topic Trailing 4 Week Average in DAX Commands and Tips

Trailing 4 Week Average

BabyBinki821 — Tue, 12 Apr 2022 18:56:56 GMT

So I thought I had this solved but i don't 😞 I need 4 week trailing average of the number of orders. Below you can see the graph I am trying to create . The formula below looks like it works but its giving me the current week - 3 previous weeks average. If I change the -3 to -4 I get very different numbers as well.

Measure = calculate(AVERAGEX(values('DATE'[Week Rank]),Orders[Total Orders]),filter(all('DATE'),'DATE'[Week Rank]>=max('DATE'[Week Rank])-3 &&'DATE'[Week Rank]<=max('DATE'[Week Rank])))

Re: Trailing 4 Week Average

amitchandak — Wed, 13 Apr 2022 01:27:14 GMT

BabyBinki821 , If you do not want this week

Measure = calculate(AVERAGEX(values('DATE'[Week Rank]),Orders[Total Orders]),filter(all('DATE'),'DATE'[Week Rank]>=max('DATE'[Week Rank])-4 &&'DATE'[Week Rank]<=max('DATE'[Week Rank])-1 ))

Measure = calculate(AVERAGEX(values('DATE'[Week Rank]),Orders[Total Orders]),filter(all('DATE'),'DATE'[Week Rank]>=max('DATE'[Week Rank])-5 &&'DATE'[Week Rank]<=max('DATE'[Week Rank])-1 ))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Trailing 4 Week Average

BabyBinki821 — Wed, 13 Apr 2022 01:37:28 GMT

Thank you!!! It worked!