Reply
justine08
Regular Visitor

Help regarding rolling average

I have below type of "actuals" data:

 

justine08_0-1688387250707.png

 

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:

justine08_2-1688387439811.png

 

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??

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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.

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

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.

Noted thanks!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)