Hi Robert,
The formula as is is dynamic, in that it will calculate the total cumulative sales over any period and then divide that by the number of days where there were sales
Avg. Daily Run Rate (Dynamic) =
VAR DaysWithSales = CALCULATE( COUNTROWS( Dates ), FILTER( ALLSELECTED( Dates ), [Total Sales] > 0 ) )
VAR CumulativeTotal = CALCULATE( [Cumulative Sales], ALLSELECTED( Dates ) )
RETURN
DIVIDE( CumulativeTotal, DaysWithSales, 0 )
The one thing with this formula is that the numbers are not static. As each new day comes in the run rate would adjust. (this may or may not be what’s needed )
Here’s video with a different technique for doing that, which just average up historic years. Is this helpful
You could adjust this for financial years.
Let me know about this or if you are looking for something different
Thanks