Sum of last 12 months counting selected month

[Anonymous]

Hello,
First, I begin by thanking you for your answers and support for all those who are passionate about Power BI.

Please, as it is indicated in this two attached files below, I would like to display the sum of last 12 months, ie when I tick in my report the month of May 2018, I would like to calculate the average from last 12 months counting from May (ie from June 2017 -> May 2018).

But as you look in the attached files below, for the normal sum formula and the sum of last 12 months always I had the same result !!!!! which is too weird
Look at these two attached files below.

Thank you a lot.

Cordially.

[v-danhe-msft]

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible?

You could see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He

[Anonymous]

Hello,
I did not find a solution for this problem.
Here is the link of my .pbix file

https://drive.google.com/open?id=1rMVWw7OwXtokFvoKVOqKuey0Wx-nPJ8g

I thank you very much.