Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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
Super User
_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
Super User
_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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors