Moving Average with TimeStamps

[Kolumam]

Hi All,

Can somebody help to explain me the formula with the help of comments please? It calculates the moving average of 15 points but I don't understand how it works.

15 min ago =  'Table'[DateTime]-15/(24*60)

15 min Moving Average =
CALCULATE (
    AVERAGE ( 'Table'[Amount] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[DateTime] <= MAX ( 'Table'[DateTime] )
            && 'Table'[DateTime] >= MAX ( 'Table'[1 min ago] )
    )
)

 @Zubair_Muhammad @Anonymous 

[v-juanli-msft]

Hi @Kolumam 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Kolumam 

1.

For the first column,

The default calculation level is ‘Day’. So, ’15mins’ need to be converted to ‘15/(24*60) days’.

2.

For the second measure, I think ‘'Table'[1 min ago] ‘ should be ‘'Table'[15 min ago] ‘. Right?

Select 15mins as the time range.

AVERAGE ( 'Table'[Amount] ) is to calculate the average of [Amount].

The filter expression is to filter out the eligible data which is between the datetime of current row and 15mins ago.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.