cancel
Showing results for
Did you mean:
Frequent Visitor

## dax

I'm Unable to calculate moving/running average using

Average Cost moving = AVERAGEX (

WINDOW( 1,ABS, 0,REL,

SUMMARIZE(ALLSELECTED('Custom Calendar Table'), 'Custom Calendar Table'[FY], 'Custom                                                  Calendar Table'[Month Name]),

ORDERBY('Custom Calendar Table'[FY], ASC, 'Custom Calendar Table'[Month Name], ASC)), [Actual                                           Cost] )

Results is

Average Cost moving     Actual Cost     Month Name   FY

220599.2747                   220599.2747   Dec                   FY 22-23

219440.6214                   219440.6214    Jan                    FY 22-23

216470.4219                   216470.4219    Feb                    FY 22-23

I am not getting Running Average of Actual cost, plz suggest the correct way of DAX code

1 ACCEPTED SOLUTION
Super User

I think the problem is the sort order, you're sorting by month name but I think you want to sort by month number. try

``````Average Cost moving =
AVERAGEX (
WINDOW (
1,
ABS,
0,
REL,
SUMMARIZE (
ALLSELECTED ( 'Custom Calendar Table' ),
'Custom Calendar Table'[FY],
'Custom Calendar Table'[Month Name],
'Custom Calendar Table'[Month number]
),
ORDERBY ( 'Custom Calendar Table'[FY], ASC,
'Custom Calendar Table'[Month Number], ASC )
),
[Actual Cost]
)
``````
Super User

I think the problem is the sort order, you're sorting by month name but I think you want to sort by month number. try

``````Average Cost moving =
AVERAGEX (
WINDOW (
1,
ABS,
0,
REL,
SUMMARIZE (
ALLSELECTED ( 'Custom Calendar Table' ),
'Custom Calendar Table'[FY],
'Custom Calendar Table'[Month Name],
'Custom Calendar Table'[Month number]
),
ORDERBY ( 'Custom Calendar Table'[FY], ASC,
'Custom Calendar Table'[Month Number], ASC )
),
[Actual Cost]
)
``````

Announcements

#### Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors