I am currently working with a large data set and I am using created date as the driver for the majority of my reports. Currently created date spans from 01/01/2016 to current day but will be including much more history soon. The way I have the data set up wtih measures now is to look at this year and last year based on the year of the creation date. Now I am being asked to be able to filter the data to one set of time and compare the second set to that first one. Meaning If they set the first set to 1/1/2016 to 5/1/2016 they want to compare it second set of data on the same graph of 1/1/2017 to 5/1/2017. So what I did was create a copy of the created date and give them seperate names and update the measures to look at the different date sets and then use those as my filters to adjust the data. So Created date 1 and Created date 2 on the same graph for time frames that are the same months but for different years. When I did this and updated the measures that the graph is based on the graphs went blank. My data set is to large and diverse to create a key to link it to a duplicate of itself and I am not out ideas. I tried to have a year and a quarter filter but was told that was not ideal for what was wanted being that they want more flexability in being able to pick date ranges to compare.
