cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

## 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 :

 Dia Valor TAM 01/10/2016 638 02/10/2016 827 03/10/2016 771 04/10/2016 359 648,75 05/10/2016 271 557 06/10/2016 147 387 07/10/2016 812 397,25 08/10/2016 749 494,75 09/10/2016 599 576,75 10/10/2016 254 603,5 11/10/2016 848 612,5 12/10/2016 164 466,25 13/10/2016 515 445,25 14/10/2016 529 514 15/10/2016 702 477,5 16/10/2016 216 490,5 17/10/2016 722 542,25 18/10/2016 988 657 19/10/2016 342 567 20/10/2016 188 560 21/10/2016 494 503 22/10/2016 673 424,25 23/10/2016 363 429,5 24/10/2016 124 413,5 25/10/2016 898 514,5 26/10/2016 510 473,75 27/10/2016 116 412 28/10/2016 993 629,25 29/10/2016 112 432,75 30/10/2016 578 449,75 31/10/2016 500 545,75 01/11/2016 627 454,25 02/11/2016 500 551,25 03/11/2016 288 478,75 04/11/2016 471 471,5 05/11/2016 613 468 06/11/2016 844 554 07/11/2016 190 529,5 08/11/2016 606 563,25 09/11/2016 444 521 10/11/2016 429 417,25 11/11/2016 147 406,5 12/11/2016 370 347,5 13/11/2016 193 284,75 14/11/2016 353 265,75 15/11/2016 859 443,75 16/11/2016 582 496,75 17/11/2016 107 475,25 18/11/2016 824 593 19/11/2016 107 405 20/11/2016 979 504,25 21/11/2016 389 574,75 22/11/2016 260 433,75

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

Kind Regards,

2 REPLIES 2
Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

New Member

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 :

 Dia Valor TAM 01/10/2016 638 02/10/2016 827 03/10/2016 771 04/10/2016 359 648,75 05/10/2016 271 557 06/10/2016 147 387 07/10/2016 812 397,25 08/10/2016 749 494,75 09/10/2016 599 576,75 10/10/2016 254 603,5 11/10/2016 848 612,5 12/10/2016 164 466,25 13/10/2016 515 445,25 14/10/2016 529 514 15/10/2016 702 477,5 16/10/2016 216 490,5 17/10/2016 722 542,25 18/10/2016 988 657 19/10/2016 342 567 20/10/2016 188 560 21/10/2016 494 503 22/10/2016 673 424,25 23/10/2016 363 429,5 24/10/2016 124 413,5 25/10/2016 898 514,5 26/10/2016 510 473,75 27/10/2016 116 412 28/10/2016 993 629,25 29/10/2016 112 432,75 30/10/2016 578 449,75 31/10/2016 500 545,75 01/11/2016 627 454,25 02/11/2016 500 551,25 03/11/2016 288 478,75 04/11/2016 471 471,5 05/11/2016 613 468 06/11/2016 844 554 07/11/2016 190 529,5 08/11/2016 606 563,25 09/11/2016 444 521 10/11/2016 429 417,25 11/11/2016 147 406,5 12/11/2016 370 347,5 13/11/2016 193 284,75 14/11/2016 353 265,75 15/11/2016 859 443,75 16/11/2016 582 496,75 17/11/2016 107 475,25 18/11/2016 824 593 19/11/2016 107 405 20/11/2016 979 504,25 21/11/2016 389 574,75 22/11/2016 260 433,75

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

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors