Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Single value for a column cannot be determined

Hi,    I am trying to create a measure so that I can calculate a rolling 4 interval average (I only have interval # and no date). However when trying to use an index to order the intervals, I recei...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Inside FILTER, instead of 'Rolling Table', use ALL ( 'Rolling Table' ),

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

Would you please copy/paste the code here so I can edit it

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you so much! Posting final DAX expression should anybody need to reference it:

 

Moving Average =
VAR MyIndex = selectedvalue('Rolling Table'[Index])
VAR myResult =
AVERAGEX(
FILTER(
ALL('Rolling Table'),
'Rolling Table'[Index] > MyIndex-4 &&
'Rolling Table'[Index] <= MyIndex
),'Rolling Table'[EDD]
)
RETURN FIXED(myResult,2)