Power Pivot DAX average calculation of a time period

Hi,
i'd like to calculate the average of a cumulative figures by a given time interval, so example 7 days, so the total for a rolling 7 day period would be divided by 7, not the number of figures in that interval;

So if between 11th and the 17th there were 2 returns that that would be the total divided by 7 not 2.

Just dividing by 7 is fine once you have more than seven dates, in excel I'd use ROW() inside an if statement as the divosor;

Please Login or Register  to view this content.

I've been trying to come up with something similar in DAX, but can't find a function similar to ROW() ,

is there a way around this I was going to try datesbetween but if anyone has any suggestions ( helpfull 😀 )

workbook attached.

Richard

maybe

https://learn.microsoft.com/en-us/dax/row-function-dax

I've used this but will go through your suggestion,

Please Login or Register  to view this content.

Then to get 1,2,3,4,5,6 and then 7 onwards,

Please Login or Register  to view this content.

and lastly

Please Login or Register  to view this content.

Seem to work, I'll let you know how I get on with your suggestion,

Richard.

BTW, I did realize after posting I'd overcomplicated, and I could use the count for everything, I just had the excel structure on the brain.

Richard.