I need a formula for a 12 Month Rolling Average. Hoping to use a quick measure.

[jonnyA]

I need a formula for a 12 Month Rolling Average. Hoping to use a quick measure.  Can anyone help?

For example, if i had 2 years worth of data, lets say all of 2020 and all of 2021 and I only want to bring back the 12 Month Average of the last 12 months.  How can I do that?

CPT  = cOUNTROWS (

groupby (Dataset,Dataset[Date_of_Service],Dataset[Patient_FullName],Dataset[Provider_name],Dataset[Procedure_Code], Dataset[Visit_Type_Status], Dataset[Voucher_Number] ))

[jonnyA · Accepted solution]

Last 12 Months V1 =

CALCULATE (

[CPT Working],

DATESINPERIOD (

'Calendar'[dt], -- returns period from date column

MAX ( 'Calendar'[dt] ), -- starting from MAX date

-12, -- shifting it back 12 intervals

MONTH -- each interval being a month

)

)

--------------------------

Then ...

365 = 365

---------------------------------

Then ... 

Last 12 Months V1 divided by 365 =

DIVIDE([Last 12 Months V1], [365])

[Anonymous]

i jopnnyA

Look at this video all is explain

https://www.youtube.com/watch?v=ACvYaXnpyCM