Forum Discussion

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago

Avg Temp for specifc dates

Hi! I am trying to pull the average temperature for a specific date/city so we can see how far above or below tomorrows forecast is. Any ideas? i tried the below, but it did not work.      Avg T...
Need Help
lszymk97's avatar
lszymk97
Frequent Visitor
2 years ago

Hello,
Can you try to use below? Your formula references a 'Dates' table in the DATESINPERIOD function, but then tries to filter the 'weather history' table. 

Avg Temp = CALCULATE( AVERAGE('weather history'[temp]), FILTER( ALL('weather history'), AND( 'weather history'[city] = SELECTEDVALUE('weather history'[city]), 'weather history'[datetime] <= SELECTEDVALUE('weather history'[datetime]), 'weather history'[datetime] > DATEADD(SELECTEDVALUE('weather history'[datetime]), -5, YEAR) ) ) )

  • ebrownretail's avatar
    ebrownretail
    Resolver I
    2 years ago

    i got this error for this