Custom End Date

[Anonymous]

Select a end date from a filter and use it to calculate last 90 days and last 120 days. The Custom End date should not apply to any visual on the report. it should only be used for calculation (last 90 and 120 days)

I am currently doing this 

 VAR OneYearAgo =  CALCULATE(

    COUNTROWS('DateTable'),

 FILTER('DateTable',

 'DateTable'[Month Year]>=MaxDate-90 && 'DateTable'[Month Year]<=MaxDate)
but it is only returning the selected end date and not the range, please help!

[Anonymous · Accepted solution]

Thanks a lot for your responses! I used a disconnected date table to get the end date now this code works perfectly!

VAR MaxDate =  SELECTEDVALUE('DisconnectedTable'[Month Year])

 VAR OneYearAgo =  CALCULATE(

    COUNTROWS('DateTable'),

 FILTER('DateTable',

 'DateTable'[Month Year]<=MaxDate && 'DateTable'[Month Year]>=MaxDate-90)

[Ashish_Mathur]

Hi,

This pattern should work.  I have assumed that you have already written a measure named MaxDate.

VAR OneYearAgo =  CALCULATE(COUNTROWS('DateTable'),DATESBETWEEN(Calendar[date],[MaxDate]-90,[MaxDate]))

[lbendlin]

Is that 'DateTable' disconnected from your data model?

[Anonymous]

No the datetable is connected