Dynamic Date Filter: Use Relative Date Filter to drive dates in separate visual?

[Anonymous]

Hey everyone, 

I am currently working on a Weather Data Report. Here is what it contains: 

1. In my top visual I am grabbing the hourly average temperature over the next 7 days per zip code using a Relative Date Filter.
2. In the bottom visual, im using a SQL query to grab the daily historical average temperature for each distinct date available.

This is where I need you guys. Is it possible to grab the dates that the next 7 days relative date filter is using (top visual) and applying those to the bottom visual minus 1 year? Basically I just want to grab whatever dates are in the top visual, and apply those same dates to the bottom visual but for the previous year.  

Any ideas? 

[Tad17]

Hey @Anonymous 

You can try using a measure with the SAMEPERIODLASTYEAR function in DAX: https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Let me know if that helps.

[Anonymous]

I can definitely use that if i find a dax formula that can imitate what my relative date filter is doing. So ill need a dax formula to grab the current data and the next 7 days. Once i figure that out i should be able to use SAMEPERIODLASTYEAR

Thanks @Tad17 

[Tad17]

@Anonymous Is this what you're looking for: https://docs.microsoft.com/en-us/dax/dateadd-function-dax

P.S. You can also use TODAY() in DAX.

[Anonymous]

@Tad17  Thank you! This seems to be on the right track. Ill post if its the solution. I appreciate it

[fhill]

Can you create a new custom column from your Zip Data equal to the Date less 1 year?  Then use that Custom column as part of the SQL query to pull in only the dates you want?

FOrrest

[Anonymous]

I'll look into that real quick. Thanks @fhill