Daily rolling average for total transactions

Hi jason435,

From your description, per day has multiple transactions, you want to do moving 7 days average for everyday total transactions, right?

Assume the sample data like below:

You can create a summarized table to aggregate total transactions per day, then create a calculated column to do moving 7 days average. For details, you can download attached pbix file.

Table = SUMMARIZE('Patient Visits','Patient Visits'[Date],"TotalRevenue",SUM('Patient Visits'[Patient_Revenue]))

Calc_7daysrolling = CALCULATE( AVERAGEX(ALLSELECTED('Table'),'Table'[TotalRevenue]), DATESINPERIOD('Table'[Date], LASTDATE('Table'[Date]),-7,DAY))

Best Regards,
Qiuyun Yu