how to calculate average per day/month

[MEDHA07]

Hi All,

I need to calculate the 3 measures .

first measure perday total records count

Second measure Average per day

Third measure Total average on month

below is my data set:

how to show each date today records+previoustotalrecordscount?

how to calculate dynamically subtracting each day’s results from the previous day’s results by category.today records minus previous daytotalrecords.

adding each day’s “Per Day” count to the previous results and dividing by the number of days in the month 

11/30/2020	3493912		Avg/day/Month
12/1/2021	3495298
Per Day	1,386	1,386
Avg/Day/Mo	1,386		1386/1
12/2/2021	3,503,457
Per Day	8,159	8159	1386+8159/2
Avg/Day/Mo	4,773
12/3/2021	3,509,552
Per Day	6,095	6095	1386+8159+6095/3
Avg/Day/Mo	5,213
12/4/2021	3,509,552
Per Day	0	0	1386+8159+6095/4
Avg/Day/Mo	3,910
12/5/2021	3,509,552
Per Day	0	0	1386+8159+6095/5
Avg/Day/Mo	3,128
12/6/2021	3,521,631
Per Day	12,079	12709	1386+8159+6095/6
Avg/Day/Mo	4,620
12/7/2021	3,524,264	28,349	total/30 days
		Total average per day

[abhijitnalekar]

Hi @MEDHA07 ,

Please use  this formula.

rangesum(above(
num(Sum({$ <InvoiceDate={"$(='>=' & Date(MonthStart(Max(InvoiceDate)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max(InvoiceDate)), 'MM/DD/YYYY'))"}>}
sale),vCurr),0,RowNo()
))/max(day(InvoiceDate))