Calculations do not work properly

[sheady]

Hey everybody,

I am struggling with some problems when I try to recreate formulas. For instance, I tried to imitate this simple building block, but I get missing values instead of a moving average.

http://insightextractor.com/2013/06/17/ ... g-average/

My resulting table looks like this:

01.06.2013 50 50
02.06.2013 40
03.06.2013 30
04.06.2013 20
05.06.2013 10
06.06.2013 10 10
07.06.2013 20 20
08.06.2013 30
09.06.2013 40
10.06.2013 50

What am I doing wrong?

With best regards
Lukas

[MattAllington]

It looks like you are not using a calendar table.
https://exceleratorbi.com.au/power-pivo ... ar-tables/
https://exceleratorbi.com.au/dax-time-i ... beginners/