Showing sales data in the previous N month (N is input from user)

[hainguyen28]

I currently have a graph that display sales within the previous 13 months. The user can choose the year and month, and the graph would show sales in the 13 months prior (including the month of their choice). Below is the screenshot:

Here is the measure I created for the Total sales - Last 13 months:

Right now, I am being asked to adjust the graph, adding another filter called "Number of months", where user can select a number between 3 and 15. For example, if the user chooses 3, then the graph will display sales in the previous 3 months. If the user chooses 10, then the graph will show sales in the previous 10 months. Does anyone have an idea how I can do this?

[Uzi2019 · Accepted solution]

Hi @hainguyen28 

yes. you can simply create number parameter .

then adjust you range accordingly.

Then 

change your measure where you have put 13 month 

use selectedvalue([Month parameter]))

so it will take your input instead of 13 it will take user input.

make sure put negative (-) sign with selectedvalue([Month parameter]))

I hope I answered your question!

[hainguyen28]

Thank you. This is exactly what I was looking for. I was able to add the parameter and adjust my measure accordingly.