Moving Averages, Sums, Etc.

I realized recently that this topic has never been covered before, in its most straightforward form, on this site! Actually, it was the subject of a guest post by the esteemed David Churchward, and also by the equally-esteemed Kasper de Jonge, but neither of those posts benefited from the v2 functions available to us today).

To illustrate what we can do with state-of-the-art Power Pivot formulas, let's start with this simple model: