Different Date slicer for Different Columns

Question

Hi,I want to apply different date slicer for different column in my grid.&nbsp;eg:&nbsp;&nbsp;Here, I want to compare metric 1 (for a specified date range) to metric 2 (for a different specified date range.&nbsp;Please Help!

pauldbrown · Answer

Anonymous&nbsp;One way of doing it:1) create a duplicate of your date table, with no relationship with your fact table&nbsp;2) create measure for your metric 13) create a metric measure which filters your date table based on the selection in your second date table (Metric 2 Date table):Metric 2 = CALCULATE(SUM('Fact Table'[Target]); 
        TREATAS(VALUES('Metric 2 Date Table'[Metric 2 Month-Year]);'Calendar'[Month-Year]))&nbsp;and you get this:&nbsp;