cancel
Showing results for
Search instead for
Did you mean:
Helper III

## 12week rolling average

Hi Experts

need to calculate the 12 week rolling average see sample data - PS i have all the necessary columns in my DimDate Table, i want to plot the 12 week rolling average in a graph

sample Data

1 ACCEPTED SOLUTION
Solution Sage
_12wk Average =
VAR Week = CALCULATE(DISTINCTCOUNT('Date'[Week]),FILTER(
ALL('Date'),
(
(
'Date'[Week]
>= MAX ('Date'[Week] ) - 11
)
&& (
'Date'[Week]
<= MAX ( 'Date'[Week] ) - 0
)
)
))
VAR Total=CALCULATE(SUM('Table'[Sales]),
FILTER(
ALL('Date'),
(
(
'Date'[Week]
>= MAX ('Date'[Week] ) - 11
)
&& (
'Date'[Week]
<= MAX ( 'Date'[Week] ) - 0
)
)
))

RETURN
DIVIDE(Total,Week,12)
1 REPLY 1
Solution Sage
_12wk Average =
VAR Week = CALCULATE(DISTINCTCOUNT('Date'[Week]),FILTER(
ALL('Date'),
(
(
'Date'[Week]
>= MAX ('Date'[Week] ) - 11
)
&& (
'Date'[Week]
<= MAX ( 'Date'[Week] ) - 0
)
)
))
VAR Total=CALCULATE(SUM('Table'[Sales]),
FILTER(
ALL('Date'),
(
(
'Date'[Week]
>= MAX ('Date'[Week] ) - 11
)
&& (
'Date'[Week]
<= MAX ( 'Date'[Week] ) - 0
)
)
))

RETURN
DIVIDE(Total,Week,12)

## Helpful resources

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors