cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Resolver I

## Average and Moving average

Hi All, I need help with some basic stuff. I fried my brain and hit the dead end.

So, how can I add simple average for the whole period and 3 weeks MA to my data to get the below in bold columns?

 Week Schedule Unschedule Ave Schedule Ave Unschedule MA 3 Weeks (Schedule) MA 3 Weeks (Unschedule) 1 100 100 125 124 2 110 110 125 124 3 120 120 125 124 4 130 130 125 124 330 330 5 140 140 125 124 360 360 6 60 100 125 124 390 390 7 160 110 125 124 330 370 8 170 120 125 124 360 350 9 180 130 125 124 390 330 10 80 180 125 124 510 360 11 430 430
1 ACCEPTED SOLUTION
Community Support

Hi @tomgag

Based on my test, the "Ave Schedule" and "Ave Unschedule" provided by Greg_Deckler are right.

Then, Try the following formula to get calculated columns "3 weeks MA"

```MA 3 Weeks (Schedule) =
IF (
[Week] > 3,
SUMX (
FILTER (
ALL ( 'Table' ),
[Week] < EARLIER ( [Week] )
&& [Week]
>= EARLIER ( [Week] ) - 3
),
[Schedule]
)
)

MA 3 Weeks (Schedule) =
IF (
[Week] > 3,
SUMX (
FILTER (
ALL ( 'Table' ),
[Week] < EARLIER ( [Week] )
&& [Week]
>= EARLIER ( [Week] ) - 3
),
[Unschedule]
)
)```

Best Regards

Maggie

2 REPLIES 2
Community Support

Hi @tomgag

Based on my test, the "Ave Schedule" and "Ave Unschedule" provided by Greg_Deckler are right.

Then, Try the following formula to get calculated columns "3 weeks MA"

```MA 3 Weeks (Schedule) =
IF (
[Week] > 3,
SUMX (
FILTER (
ALL ( 'Table' ),
[Week] < EARLIER ( [Week] )
&& [Week]
>= EARLIER ( [Week] ) - 3
),
[Schedule]
)
)

MA 3 Weeks (Schedule) =
IF (
[Week] > 3,
SUMX (
FILTER (
ALL ( 'Table' ),
[Week] < EARLIER ( [Week] )
&& [Week]
>= EARLIER ( [Week] ) - 3
),
[Unschedule]
)
)```

Best Regards

Maggie

Super User

The first two are easy:

`Column Ave Schedule = AVERAGEX(ALL('Table'),[Schedule])Column Ave Unschedule = AVERAGEX(ALL('Table'),[Unschedule])`

The second two I don't understand because those look like sum's and not averages but probably something like:

```Column MA 3 Weeks (Schedule) =
SUMX(FILTER(ALL('Table'),[Week]<EARLIER([Week])&&[Week]>=EARLIER([Week])-2),[Schedule])```

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors