Calculating the moving average of previous 6 weeks sales compared to last week sales

[hibarrbm]

I need help calculate the variance between last week's sales vs. the average total of the prior 6 weeks. I've seen and found formulas that does it by day but my data only comes in fiscal weeks (Sun-Sat). Please Help!

Goal 1: Total last weeks sales - Avg. Total of prior 6 weeks = $ Variance

and

Goal 2: Total last week sales / Avg. Total of prior 6 weeks -1 = % Variance 

[Jihwan_Kim · Accepted solution]

Hi, @hibarrbm 

Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.

all measures are written in the sample pbix file.

https://www.dropbox.com/s/vd7ztj87pqs58m7/hibarrbm.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[hibarrbm]

This worked perfectly! thanks so much

[hibarrbm]

Just to clarify, i really only need help calculating the Avg. Total for last 6 weeks