Calculations do not work properly

Anything related to PowerPivot and DAX Formuale
sheady
Posts: 1
Joined: Thu Jun 27, 2019 6:05 am

Calculations do not work properly

Postby sheady » Thu Sep 17, 2020 8:46 pm

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
Posts: 1150
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Calculations do not work properly

Postby MattAllington » Sun Sep 27, 2020 7:59 am

Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests