Compare products launch with user input launch date

Hi Anonymous ,

To do this you need to make the same thing you did for the slicers of the products, create 3 tables with the dates then change your measure to:

Product comparison = VAR FirstSold =
    CALCULATE (
        MIN ( Sales[Sell_Date] ),
        Products[ProductName]
            IN {
                SELECTEDVALUE ( 'Product 1'[ProductName] ),
                SELECTEDVALUE ( 'Product 2'[ProductName] ),
                SELECTEDVALUE ( 'Product 3'[ProductName] )
            }
    )

VAR SelectionFirstDate = 
   SWITCH( MAX( Products[ProductName]),
            SELECTEDVALUE ( 'Product 1'[ProductName] ),MIN (  Product1Date[Date] ),
             SELECTEDVALUE ( 'Product 2'[ProductName] ),MIN (  Product2Date[Date] ),
             SELECTEDVALUE ( 'Product 3'[ProductName] ),MIN (  Product3Date[Date] ),
             FirstSold)
VAR LastSold =
    CALCULATE (
        MAX ( Sales[Sell_Date] ),
        Products[ProductName]
            IN {
                SELECTEDVALUE ( 'Product 1'[ProductName] ),
                SELECTEDVALUE ( 'Product 2'[ProductName] ),
                SELECTEDVALUE ( 'Product 3'[ProductName] )
            }
    )
VAR days =
    SELECTEDVALUE ( 'Days after launch'[Days] )
RETURN
    CALCULATE (
        Sales[Qty],
        FILTER (
            ALL ( 'Date' ),
            'Date'[Date] >= SelectionFirstDate + days
                &&  SelectionFirstDate + days <= LastSold
        ),
        FILTER (
            Products,
            Products[ProductName]
                IN {
                SELECTEDVALUE ( 'Product 1'[ProductName] ),
                SELECTEDVALUE ( 'Product 2'[ProductName] ),
                SELECTEDVALUE ( 'Product 3'[ProductName] )
                }
        )
    )

You can also adjust the formula to pick up the sales first day if nothing is selected on the filter, if you need help please reach out.