Converting Normal Excel function to DAX function

Hi Experts,
I am having trouble in "Converting Normal Excel function to DAX function"

So I thought, this time I should make a call for help in this forum. Hopefully will get the answer here.

The formula is to calculate Moving daily average of Last thirty days. (on I19)

Formula:

Please Login or Register  to view this content.

Actually the formula is for moving average for each route separately.

The formula works well but due to large Dataset, Excel takes too long to calculate.
As I was using Pivot as a base, So, I thought to convert it into DAX function which I am unable to do after many attempts.

I have filtered the Route column to reduce the rows. You can add more.

Thanks in advance

here is the link to file.
https://drive.google.com/file/d/0Bzt...ew?usp=sharing

I got the required solution.
Here it is

Formula:

Please Login or Register  to view this content.

Thread closed..!!

This Calculated Measure is far better.

// When Actual Trading days are to be considered. It is use full when there are gaps in the events. Like First sale happened on 1 Jan and next sale happened on 30 Jan. So the Denominator should be 2 days while calculating average while calculating average on 30 Jan, not 30 days.

Please Login or Register  to view this content.

// When Actually Trading days are not to be considered.

Please Login or Register  to view this content.

Hope it helps anybody out there!