Dynamic Date Range selection of two Date Column by 1 Slicer

[TEACHY888]

Hi Gurus, really stucked here and need some help. 

OpportunityOldValue_NewValue table got two Date Column Changed_Date and OpportunityCreatedDate .

I need to create a dateSlicer / daterange on ChangedDate column which should also filter CreatedColumn and show the amount

So far I have tried this but its not working :

NewCalculation1 =

VAR StartDate = CALCULATE(MIN(OpportunityOldValue_NewValue[Changed_Date].[Date]), ALL(OpportunityOldValue_NewValue[OpportunityCreatedDate]))

VAR EndDate = CALCULATE(MAX(OpportunityOldValue_NewValue[Changed_Date].[Date]), ALL(OpportunityOldValue_NewValue[OpportunityCreatedDate]))

VAR LatestChangedDateTime = CALCULATE(MAX(OpportunityOldValue_NewValue[Changed_Date]), ALL(OpportunityOldValue_NewValue))

RETURN

IF(ISBLANK(CALCULATE(

    SELECTEDVALUE(OpportunityOldValue_NewValue[Amount]),

    FILTER(

        OpportunityOldValue_NewValue,

        OpportunityOldValue_NewValue[Changed_Date] = LatestChangedDateTime &&

        OpportunityOldValue_NewValue[Changed_Date] >= StartDate &&

        OpportunityOldValue_NewValue[Changed_Date] <= EndDate &&

        OpportunityOldValue_NewValue[OpportunityCreatedDate] >= StartDate &&

        OpportunityOldValue_NewValue[OpportunityCreatedDate] <= EndDate

    )

)), 0,

CALCULATE(

    SELECTEDVALUE(OpportunityOldValue_NewValue[Amount]),

    FILTER(

        OpportunityOldValue_NewValue,

        OpportunityOldValue_NewValue[Changed_Date] = LatestChangedDateTime &&

        OpportunityOldValue_NewValue[Changed_Date] >= StartDate &&

        OpportunityOldValue_NewValue[Changed_Date] <= EndDate &&

        OpportunityOldValue_NewValue[OpportunityCreatedDate] >= StartDate &&

        OpportunityOldValue_NewValue[OpportunityCreatedDate] <= EndDate

    )

))

Really need some helpm here and any input would be appriciated , thanks

[lbendlin]

create an active relationship between the date on your calendar table and the create date. Create an inactive relationship between the calendar date and the change date.  use USERELATIONSHIP in your measures to toggle between the joins.