cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ndomell New Member
New Member

Calculate the average of the last six months

Hello,

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

Here is my issue:Power.PNG

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate the average of the last six months

@ndomell ,

 

You may try using AVERAGEX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Calculate the average of the last six months

@ndomell ,

 

You may try using AVERAGEX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
melle21 Visitor
Visitor

Re: Calculate the average of the last six months

Thank you @v-chuncz-msft 

 

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

 

Thanks a lot.