Wondering if their is a way to use two Date Slicers that a user would selected and perform a Calculation based on Dates in the first Date Slicer and a Calculation for the selection in the Second Date Slicer.
Calculate Total Qty Sold by Item for two user defined ranges.
Date 1 - User Selects 11/1/17 - 10/31/18 Calculation looks at the fact Table and Calculates for that Range
Date 2 User Selects 11/1/16 - 12/31/17 Calculation looks at the same fact Table and Calculates for the second range.
You ultimately would end up with Two Measures one for Total Qty Sold for the Date 1 Selection, and another for Total Qty Sold for the Date 2 Selection.
Hope that makes sense.