I am currently working on a Weather Data Report. Here is what it contains:
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.
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?
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.
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
@tbuckingham 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.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!