Forum Discussion
Rolling Average on non-summarized data
I'm trying to create a rolling average measure but instead of returning the average of the period, I just get the total for the single date/7. I've tried multiple measures using the days in period f...
UPDATE: After further review, the problem is caused because I have the applicable date field set to Date Hierarchy. When I changed that, all the rolling average measures began working.