Calculate the average of the last six months

[Anonymous]

Hello,

I am new in Power BI and i need your help. 

Here is my issue:

I have in my model 3 tables (Time, Reservations, Stock)

The purpose of the report is to calculate the flow of the stock (in french : taux d'écoulement); when you select a period, you display the data for the last 6 months.

ie if I select March-2019 I display the data from Oct 2018 to March 2019)

So I created my measures:
- reservations last 6 months
- stock last 6 months
- flow of the stock (in french "taux d'écoulement") for last 6 months (which represents the division of the number of reservation / stock)

My problem,
calculate the average of the flow of the stock ( in french "taux d'écoulement") that you will see in red in the file. An idea would be a  great help to me.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try using AVERAGEX.

• https://community.powerbi.com/t5/Desktop/I-want-to-get-an-average-of-three-months-from-next-month-to/m-p/634808#M303627
• https://community.powerbi.com/t5/Desktop/Monthly-Average-of-Previous-5-Years/m-p/436730#M201414

[Anonymous]

Thank you @v-chuncz-msft 

i had tried AVERAGEX before but i think i used it in the wrong way.

Thanks a lot.