- 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
Help regarding rolling average
I have below type of "actuals" data:
Since latest actual data is just for May, average for the last 6 months is easy to calculate. The columns are measures that I calculated based on a sample data below:
This is just a sample data but the main issue that I have is that the dates are in the columns which is making it harder for me to actually use DAX to use dates.
Are there any other ways to calculate the rolling average once for example July data is now set (then 6 month average is from Feb to July, and so on.) keeping them in the column??
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You would be much better off using Power Query to unpivot the date columns so that you only have 3 columns - customer, date and value. You can then implement a date table and all of your date-based calculations will be much simpler.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You would be much better off using Power Query to unpivot the date columns so that you only have 3 columns - customer, date and value. You can then implement a date table and all of your date-based calculations will be much simpler.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Noted thanks!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-23-2024 01:39 AM | |||
12-24-2024 09:55 AM | |||
07-28-2024 10:29 AM | |||
Anonymous
| 10-23-2024 01:51 AM | ||
12-20-2024 06:44 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |