I am having issues calculating a moving average. I think there may be something wrong with my Date column? When I try to calculate a 7 day rolling average in a new column "RollAvg1" with the DAX code from the Quick Measure, the result is only averaging one row (one day), not the full 7 day window I want. I've tried removing the .[Date] suffix and it still did not work. It looks like the Time Intelligence is working within PowerBI because the automatic date table is generating, but the Date is greyed out.