Getting last 90 days of data

[Gumberculeez]

Hey all;

I'm trying to create a real time DSI and having difficulty on the last 90 days measure.  

Here is my measure below, and it "passes" however I get the following error.

Rev90 = CALCULATE([Revenue], DATESINPERIOD(GLTransDetails[Date], TODAY(), -90, DAY))

is there another "dates" DAX variable I should be using to get my last 90 days of sales?

[Gumberculeez · Accepted solution]

Thanks to GPT :)... got it to work.  For FYI:

Rev90 = CALCULATE(

    [Revenue],

    FILTER(

        'GLTransDetails',

        'GLTransDetails'[Date] >= TODAY() - 90 && 'GLTransDetails'[Date] <= TODAY()

    )

this pulls passes, and does not error.

[amitchandak]

@Gumberculeez , if you need based on today

Last 90 =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = _max -90
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

or

Last 90 =
var _max =  today()
var _min = _max -90
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

or

Last 90 =
var _max =  today()
var _min = _max -90
return
CALCULATE([net] ,filter('Date','Date'[Date]>= _min && 'Date'[Date] <= _max))

[Gumberculeez]

Both of those generate the same error.