Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Could you please share some sample data and clairfy more details about your requirement?
Regards,
Jimmy Tao
@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
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))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |