topic Re: Help regarding rolling average in DAX Commands and Tips

Help regarding rolling average

Anonymous — Mon, 03 Jul 2023 12:37:09 GMT

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

Re: Help regarding rolling average

johnt75 — Mon, 03 Jul 2023 12:56:06 GMT

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.

Re: Help regarding rolling average

Anonymous — Mon, 03 Jul 2023 12:57:29 GMT

Noted thanks!