Data filtering using multiple date columns of a table

Thankyou for the reply.

I have tried the same way as mentioned in your approach 1( without relationship between time(calendar) and proposals table)

But could not able to see the expected result.

Please find the below screen shot

Always Measure displays the value with "0" even though the product_sid's initiationdate, responsedate, completedate falls within the range of date prompt. For example, please verify for the product_sid 35659008, 35659015. The formula which is used is mentioned below

Measure  = VAR initiationdate = MIN(proposals[initiationdate]) VAR responsedate = MIN(proposals[responsedate]) VAR completedate = MIN(proposals[completedate])  RETURN IF (
        (
            initiationdate >= MIN ( 'time'[Date] )
                && initiationdate<= MAX ( 'time'[Date] )
        )
            || (
                proposeddate>= MIN ( 'time'[Date])
                    && proposeddate<= MAX ( 'time'[Date])
            )
            || (
                completedate >= MIN ( 'time'[Date])
                    && completedate <= MAX ( 'time'[Date] )
            ),
        1,
  0
    )

Please help me in understanding why does always  measure shows the value 0 instead of displaying 1 even for the records which falls into the date range prompt.

Approach2:

Proposals table is very large data set with minimum of 16 millions of records. Does unpivot of table proposals and having the relationship with time table works? Please clarify.