what if parameter =1 how to make it return 3 ?

[Anonymous]

Hi All

I have Crate the below script :-

Rolling = CALCULATE(sum(CRM_TS_[Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(CRM_TS_[Closing Date]),-1 * selectedvalue(Parameter[parameter]),MONTH))

Now the issue is :-

When I select parameter value = 1 , it should display 3 ( 1+2=3) but it display 4.

Hope you can share with me where go wrong ?

I have create a PBI File :-

https://www.dropbox.com/s/k5csyzge8kjz1wy/NEXT3MTH%20V001%20ASH%20SOLUTION_6.pbix?dl=0

[amitchandak · Accepted solution]

@Anonymous , This working correct order is from last date.

Try this

Rolling 1 = CALCULATE(sum(CRM_TS_[Amount]),DATESINPERIOD('Date'[Date],eomonth(Min(CRM_TS_[Closing Date]),-1)+1, selectedvalue(Parameter[parameter]),MONTH))
or
Rolling 2 = CALCULATE(sum(CRM_TS_[Amount]),DATESINPERIOD('Date'[Date],eomonth(Min(CRM_TS_[Closing Date]),-1)+1, selectedvalue(Parameter[parameter]) -1 ,MONTH))