How to achieve running average?

[Anonymous]

I have the next fact table:

Users	Date
1	01-June-2022
1	01-July-2022

On my .pbix I have a Year-Month filter…

I want to see the “running average” (starting every year at June-01)

If JUNE is selected I want to see 1.     (math: 1/1)

If JULY is selected I want to see 1.       (math: 2/2)

If AUGUST is selected I want to see 0,66     (math: 2/3)

If SEPTEMBER is selected I want to see 0,5     (math: 2/4)

And so on… how can I achieve this?

[wdx223_Daniel]

Measure=VAR _tbl=CALCULATETABLE(ADDCOLUMNS(VALUES(DateTable[YearMonth]),"@cnt",CALCULATE(COUNTROWS(UserData)))+0,DateTable[Date]<=MAX(DateTable[Date])) RETURN SUMX(_tbl,[@cnt])/COUNTROWS(_tbl)