My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Average for Years 2018-2022 with Power Pivot DAX|Power Pivot|Excel Forum|My Online Training Hub

You are here: Home / Average for Years 2018-2022 with Power Pivot DAX|Power Pivot|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Average for Years 2018-2022 with Power Pivot DAX
Avatar
Robert Rafferty
Member
Members
Level 0
Forum Posts: 39
Member Since:
September 15, 2020
sp_UserOfflineSmall Offline
1
December 29, 2023 - 8:48 am
sp_Permalink sp_Print

Hi Mynda and Phillip:

I am starting to seriously work with Power Pivot, and my first step is digging deeper into DAX with Power Pivot.

How do I get the average of 4 rows (4 years) for my  Boeing Invested Capital calculation in Power Query in a Power Pivot table?

I tried everything but DAX still eludes me at the moment.

 

Attached is my Power Query Workbook and images.

Please let me know if this works for you.

 

Happy New Year.

Robb

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4784
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
January 2, 2024 - 11:39 am
sp_Permalink sp_Print

Great to hear, Robb. Rolling averages are more complex than they appear. This article explains them for monthly rolling averages, but you can adapt it for years.

Mynda 

Avatar
Robert Rafferty
Member
Members
Level 0
Forum Posts: 39
Member Since:
September 15, 2020
sp_UserOfflineSmall Offline
3
January 5, 2024 - 10:59 am
sp_Permalink sp_Print

Awesome, Thanks

Happy New Year!

 

Regards,

Robb

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1945
SunnyKow: 1432
Anders Sehlstedt: 959
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jennifer Hull
kris king
Hasanul Karim
Terrie s
Jack Ennis
Gary Day
Michael Wiliams
Jim Collier
Allan Chan
Rik Lelliott
Forum Stats:
Groups: 3
Forums: 25
Topics: 7159
Posts: 31414

 

Member Stats:
Guest Posters: 50
Members: 34674
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen