Calculate the last 90 days average

[water-guy-5]

Hello, 

Although using a date slicer would be great, I am trying to capture a specific number using a measure.

What I have so far is a measure that reads the daily average and gives me a usage per minute value. I use usage (divided by 1000) and run time. We can call this DailyAverage. This converts usage to 1000s and hours ran to minutes.

DailyAverage =
Var Usage = SUM(Table[Usage]) * 1000
Var RunTime = SUM(Table[HoursRan]) * 60
Return
DIVIDE(Usage,Runtime)

I have a date column called Table[Date] where I want to calculate the daily readings from the last 90 days and find an average. How would this measure look?

CALCULATE(AVERAGE(Table[DailyAverage]), Date Function I am having trouble with)

Thanks in advance!

[Greg_Deckler · Accepted solution]

@water-guy-5 Maybe:

Measure = 
  VAR __Table = 
    ADDCOLUMNS(
      FILTER(Table[Date], [Date] >= TODAY()-90),
      "__DailyAverage",[DailyAverage]
    )
RETURN
  AVERAGEX(__Table, [__DailyAverage])