Question about comparing data from 2 time periods

[id013]

Hi,

I want to create a dashboard that compares 2 sets of dates, this year and last year. So I have a fact_volumes table that has volume data for the last 2 years (Jan 1 2019 to present) and it is linked to a date dimension table that has the same dates (Jan 1 2019 to Present).

The idea being that I select a time period (ex. Jan 1 2020 - March 31 2020) and I will be able to see volumes for the time period I've selcted Jan 1 2020 - Mar 31 2020 as well as the volumes for the same period of the previous years so Jan 1 2019 - Mar 31 2019. 

I know I can create the measures using the sameperiodlastyear function, the wrinkle I'm running into is that I only want the user to ony be able to select from a date range of this year. So the date slicer they see will only show the date range of Jan 1 2020 - Present Date. I've tried setting a filter on the date slicer to only show this years dates and it works fine as long as the date slicer is actively filtering dates, the problem is if you clear the filtering even though the date slicer shows this years dates, the volume measures are showing me the volumes for the whole 2 year period that is in my data set? 

Is there a better way to do this?

Thanks

[v-jayw-msft · Accepted solution]

Hi @id013 ,

You could use page level filter and create measures as below.

this year = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]>=MIN('Table'[date])&&'Table'[date]<=MAX('Table'[date])))

previous year = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[date]>=EDATE(MIN('Table'[date]),-12)&&'Table'[date]<=EDATE(MAX('Table'[date]),-12)))

Best Regards,

Jay

[id013]

Thanks to everyone this was very helpful. I was able to accomplish what I needed by tweaking the logic in the measures like everyone suggested. 

[Greg_Deckler]

@id013 - Seems like you would have to build that filter into your measures. 

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@id013 , See if this can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601