Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
92
Views
Topic starter
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
Posted : 29/12/2023 6:48 pm
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
Posted : 02/01/2024 9:39 pm
Topic starter
Awesome, Thanks
Happy New Year!
Regards,
Robb
Posted : 05/01/2024 8:59 pm
