Forum Discussion
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 s...
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.
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!