Forum Discussion

vdomingueza's avatar
vdomingueza
New Member
9 years ago

Moving Average on weeks

Hi everyone, 

 

I'm trying to calculate moving average on 4 weeks like an Excel formula. The excel formula is calculated as a TAM(Moving Average) in Excel . 

 

The dates are the following : 

 

DiaValor TAM
01/10/2016638 
02/10/2016827 
03/10/2016771 
04/10/2016359648,75
05/10/2016271557
06/10/2016147387
07/10/2016812397,25
08/10/2016749494,75
09/10/2016599576,75
10/10/2016254603,5
11/10/2016848612,5
12/10/2016164466,25
13/10/2016515445,25
14/10/2016529514
15/10/2016702477,5
16/10/2016216490,5
17/10/2016722542,25
18/10/2016988657
19/10/2016342567
20/10/2016188560
21/10/2016494503
22/10/2016673424,25
23/10/2016363429,5
24/10/2016124413,5
25/10/2016898514,5
26/10/2016510473,75
27/10/2016116412
28/10/2016993629,25
29/10/2016112432,75
30/10/2016578449,75
31/10/2016500545,75
01/11/2016627454,25
02/11/2016500551,25
03/11/2016288478,75
04/11/2016471471,5
05/11/2016613468
06/11/2016844554
07/11/2016190529,5
08/11/2016606563,25
09/11/2016444521
10/11/2016429417,25
11/11/2016147406,5
12/11/2016370347,5
13/11/2016193284,75
14/11/2016353265,75
15/11/2016859443,75
16/11/2016582496,75
17/11/2016107475,25
18/11/2016824593
19/11/2016107405
20/11/2016979504,25
21/11/2016389574,75
22/11/2016260433,75

 

Do you have any idea how to do in Power BI?

 

Thanks in advance. 

 

Kind Regards, 

2 Replies

  • vdomingueza's avatar
    vdomingueza
    New Member
    9 years ago

    Hi everyone, I'm trying to calculate moving average on 4 weeks like an Excel formula. The excel formula is calculated as a TAM(Moving Average) in Excel . The dates are the following :

     

    DiaValor TAM
    01/10/2016638 
    02/10/2016827 
    03/10/2016771 
    04/10/2016359648,75
    05/10/2016271557
    06/10/2016147387
    07/10/2016812397,25
    08/10/2016749494,75
    09/10/2016599576,75
    10/10/2016254603,5
    11/10/2016848612,5
    12/10/2016164466,25
    13/10/2016515445,25
    14/10/2016529514
    15/10/2016702477,5
    16/10/2016216490,5
    17/10/2016722542,25
    18/10/2016988657
    19/10/2016342567
    20/10/2016188560
    21/10/2016494503
    22/10/2016673424,25
    23/10/2016363429,5
    24/10/2016124413,5
    25/10/2016898514,5
    26/10/2016510473,75
    27/10/2016116412
    28/10/2016993629,25
    29/10/2016112432,75
    30/10/2016578449,75
    31/10/2016500545,75
    01/11/2016627454,25
    02/11/2016500551,25
    03/11/2016288478,75
    04/11/2016471471,5
    05/11/2016613468
    06/11/2016844554
    07/11/2016190529,5
    08/11/2016606563,25
    09/11/2016444521
    10/11/2016429417,25
    11/11/2016147406,5
    12/11/2016370347,5
    13/11/2016193284,75
    14/11/2016353265,75
    15/11/2016859443,75
    16/11/2016582496,75
    17/11/2016107475,25
    18/11/2016824593
    19/11/2016107405
    20/11/2016979504,25
    21/11/2016389574,75
    22/11/2016260433,75

     

     

     Do you have any idea how to do in Power BI? Thanks in advance. Kind Regards,

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    create a measure

     

     

    Moving_Average_4_weeks = 
CALCULATE (
    AVERAGEX ( 'table', 'table'[valor] ),
    DATESINPERIOD (
        'table'[date]
        LASTDATE ( 'table'[date] ),
        -4,
        week
    )
)

    give this a bash vdomingueza