Forum Discussion
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...
Anonymous
Inside FILTER, instead of 'Rolling Table', use ALL ( 'Rolling Table' ),
Thank you. I tried that, however instead of calculating the average over the number of specified intervals the measure just returns the total for each. See below:
Anonymous
Inside FILTER, instead of 'Rolling Table', use ALL ( 'Rolling Table' ),