cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Rolling average by day for P3M

Hey guys!

I have a question about calculating rolling average for P3M

Here is the small example of my dataset:

As you can see here, I have shipments to the same customer at the same date with different sales amount.

And the result I want to get is attached below. The problem is that i need to calculate all sales for the period and then to calculate average for the P3M period and I dont know how to do it

Thank you guys!

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Rolling average by day for P3M

Hi @em6jq65,

```RollingAVR =
CALCULATE (
SUM ( Table[Amount(pieces)] ),
FILTER (
ALL ( Table ),
Table[Date].[Year] = YEAR ( MAX ( Table[Date] ) )
&& Table[Date].[MonthNo] <= MONTH ( MAX ( Table[Date] ) )
&& Table[Date].[MonthNo]
>= MONTH ( MAX ( Table[Date] ) ) - 2
)
)
/ 3
```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Contributor

## Re: Rolling average by day for P3M

Hi @em6jq65,

```RollingAVR =
CALCULATE (
SUM ( Table[Amount(pieces)] ),
FILTER (
ALL ( Table ),
Table[Date].[Year] = YEAR ( MAX ( Table[Date] ) )
&& Table[Date].[MonthNo] <= MONTH ( MAX ( Table[Date] ) )
&& Table[Date].[MonthNo]
>= MONTH ( MAX ( Table[Date] ) ) - 2
)
)
/ 3
```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 282 members 2,948 guests
Recent signins: