Moving Range with Live Dataset Connection

[ERIC_A]

Hi 

I have the following table1. This is connected live to the power BI dataset and I want to create a measure to calculate the moving range of Response

woid	Response
1	10
3	1
4	3
6	4
7	5
10	6
11	4
12	3
20	45
24	7
26	10

This is connected live to the power BI dataset and I want an outcome like the 3rd column shown below. 

Note: I cannot create measure columns as this is a live connected PBI dataset

woid	Response	Moving Range
1	10	0
3	1	9
4	3	2
6	4	1
7	5	1
10	6	1
11	4	2
12	3	1
20	45	42
24	7	38
26	10	3

How can I achieve this?

thank you 

[lbendlin]

You cannot do that with a live dataset. Convert to Direct Query with local model.

[ERIC_A]

If this cannot be done I wonder how the company PQsystems that sells these MR I chart visuals are able to calculate it ?