Extracting Latest 4 Points of a Measure

[Anonymous]

Hi,

I am having an issue extracting the latest 4 points of a measure. The measure I used is a rolling average and its function is as follows:

Moving_Average = 

CALCULATE(

SUMX('table','table'[Sales]),

DATESINPERIOD(

'table'[Quarter_Date].[Date],

LASTDATE('table'[Quarter_Date]),

-4,

QUARTER

)

)

The moving average formula works fine. Then I tried to extract the last 4 points' Moving Average by implement a filter, but the filter recalculated the moving averages.  Following is the filter I implemented:

VAR Last_4_Roll_4 = CALCULATE([Moving_Average], 'table'[Quarter_Order] <= 4)

Return 

Last_4_Roll_4

So is there a way to implement a filter that truncates the output after the measure being calculated?

Thanks,

TS

[v-yuta-msft]

@Anonymous,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[v-yuta-msft]

Hi TXTS23,

Modify your measure as below and check if it can work:

Result =
VAR Last_4_Roll_4 =
    CALCULATE ( [Moving_Average], FILTER ( 'table', 'table'[Quarter_Order] <= 4 ) )
RETURN
    Last_4_Roll_4

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

Hi Jimmy,

Thanks for answering.

Applying Filter function actually interrupt with the moving average and turn the output back to standalone points. 

But applying the filter directly without the Filter function seem to work in this case.

Result =
VAR Last_4_Roll_4 =
    CALCULATE ( [Moving_Average], 'table'[Quarter_Order] <= 4 )
RETURN
    Last_4_Roll_4

Thanks,

TS