- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can't get Moving Average (or sum) to work right
This is a really a simple question. Every formula I find here and elsewhere, I plug into a "moving average" column and it never produces an average. In the example below, I'm just trying to even get a sum, but I can't even get this. It simply shows what is in the column data. This data is week-end (Sunday) times. Any ideas how to get this to work? Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help. I wasn't able to get this to work in Power BI interface, so I just did it at the SQL Server level. ,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need create new measure from report. Not new column from data. I checked my data, this measuere is not shown in the table data at all.
Right click your table, you will see add new measure and put your DAX. It will work. Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is Your column calcuated average or sum? Actually it calcualte sum. To get average, you need divide 30 days.
Put my formula for your reference. It works for me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The problem is you'll see I have the same formula as you produced except for the /30. I was trying to get the sum to work before I moved on the average and it won't even do that. I probably just need to figure out how to do this at the sql server level. Probably much simpler.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The moving average I use is meant to be a measure and displayed in a visual. If you make it as a column it is averaging that specific row. Create it as a measure and use your weeks on your axis.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Well part of the reason I'm using the actual end-of-week dates is because it wouldn't sort properly, even with a sort column.
I have played around with the "measure" thing. Looks interesting but still no luck, will continue to play. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help. I wasn't able to get this to work in Power BI interface, so I just did it at the SQL Server level. ,

Helpful resources
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |