Optimizing a simple moving average measure

Hi  nbs33 ,

According to your description, you want to calculate the previous year's revenue , right?

You can try to create a measure.

Revenue 12MM =

VAR revenue12mm = CALCULATE(SUM(Invoice[Revenue]), PARALLELPERIOD(Dates[Date],-1,year))  

RETURN

IF( revenue12mm = 0, BLANK(), revenue12mm)

For more information about the function you can refer to the following documents.

PARALLELPERIOD function (DAX) - DAX | Microsoft Learn

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

After a lot of trial and error and looking at the query analizer I relized most of the time was spent joining the dimension tables to the fact table. 

To overcome this I colapsed the necessary columns of my demnsion table into may fact table and this greatly improved performance.