Average by two last week on power query or dax

[sebastianqc]

Hi all ,  I have a question, how can I average the last two fields before the current field? Example:

"Promedio" is a Average  from the fields "S4 : S5" , now from the next one i need calculate the Average  from the fields "S5:S6",how i can calculate this? , im new on Power Bi 

Thanks for the replies

[v-yuta-msft]

@sebastianqc ,

Could you please share some sample data and clairfy more details about your requirement?

Regards,

Jimmy Tao

[sebastianqc]

@v-yuta-msft  thanks for you reply

 I have the feed  4 columns: semana - vigencia - USD/m3 - CPL/m3  on the Last Table.

I have this Table
 

Sem	Día	USD/CLP	USD/m3	CLP/m3
29	lun-10-jul	664,78	413,01	274.558,36
30	lun-17-jul	655,28	423,95	277.801,44
31	lun-24-jul	649,60	439,35	285.400,28
32	lun-31-jul	651,74	455,33	296.751,79
33	lun-07-ago	649,37	450,7882	292.728,33
34	lun-14-ago	646,63	445,41	288.015,63
35	lun-21-ago	642,18	452,10	290.324,78

My problem starts here, since as I said in the header I have to feed 4 columns in power query with tables and columns from previous table; which are:

Semana, the order of a week should be shown without repeating as shown in the 3rd table "Sem"

Vigencia, must show the Thursday day of each of the corresponding weeks, associated to "Dia" from the 3rd Table

Parid_sem (USD / m3), must show the average of the last two weeks of the USD / m3 field in table number 3, example: for week 31 you must average the USD / m3 of weeks 29 and 30 of table 3 for week 32 you must average the USD / m3 of weeks 30 and 31 of table 3 and so respectively.

Parid (CLP / m3), and the last table is the average of the last two values ​​(CLP / m3) of table number three, the same as the previous example, but from the CLP / m3 column.

thanks for help me

[amitchandak]

I did not completely.

But you can last 14 days /2 weeks using

Rolling 14 day = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-14,Day))