Measure to calculate rolling monthly average

[ClemFandango]

Hi all, quite a simple problem for one of you geniuses.

I have the following simple measure that is calculating an Average by dividing the current number of months (i.e April currently = 4) from a Date table within a Card Visual.

AvgNewRolling = 
DIVIDE(SUM('RefExpand'[New]), 4)

Unfortunately, every month I have to manually update this measure (next month will be 5). Any idea how I can change this measure, so it dynamically updates without having to manually update it ?

Many thanks!

Date Table

Expanded_Date	Ref	MinDate	MaxDate	DateToday	New
01-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00	1
02-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
03-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
04-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
05-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
06-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
07-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
08-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
09-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
10-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00
11-Jan-23	2057	01/01/2018 00:00	30/09/2023 00:00	11/05/2023 00:00

PS

Apologies, I have no idea why the table formatting never works. I have read through the forum post/tutorial and tried all browsers etc.

[Ashish_Mathur]

Hi,

Does this measure work?

AvgNewRolling = 
DIVIDE(SUM('RefExpand'[New]), MONTH(TODAY()))

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523