1 Reply Latest reply on May 4, 2017 6:02 AM by lenaic.ridinger

    Filter using dates in another sheet

    Parimal Pandey

      We have two data sources one having Target date along with some other dimensions and measures. Target date is in Date time format ("yyyy'-'MM'-'dd'T'HH':'mm':'ss")

      Second source has Estimated Date which is in format ("yyyy'-'MM'") other columns are unrelated.

       

      How to use Estimated date in second datasource to show results in first data source where Target date is between two dates selected from Estimated date.