Best way to manage multiple dates

Hello Anonymous 

You can join all of your dates into the date table although only one of the connections will be the primary active one.

In my example below my primary join is on [Paid Date] with the other 4 being on [Entry Date], [Processed Date], [Received Date], and [Service Date]:

If I have a measure that calculates "Paid Amount":

Paid Amount = SUM ( vCLAIM[Paid] )

I can write another measure that will use that first measure but switches to use vCLAIM[Service Date] > DATE[Date] instead:

Paid Amount Service Date = 
CALCULATE(
    [Paid Amount],
    USERELATIONSHIP( vCLAIM[Service Date], DATES[Date] )
)

You can go a step further if you add a table of date "selections" the feed that into a measure.

This DAX will create a table in my model that I can use in another measure to switch the dates using a slicer.

Date Selction =
DATATABLE (
    "Date Type", STRING,
    "Order", INTEGER,
    {
        { "Service Date", 1 },
        { "Received Date", 2 },
        { "Entry Date", 3 },
        { "Processed Date", 4 },
        { "Paid Date", 5 }
    }
)

Then I can add my [Date Type] field to a slicer and the selection to a measure like so.  If no [Date Type] is selected is uses the [Paid Date] field:

Paid Amount with Date Selection:= 
VAR DateType =
    SELECTEDVALUE ( 'Date Selection'[Date Type], "Paid Date" )
RETURN
    SWITCH (
        TRUE (),
        DateType = "Paid Date", CALCULATE (
            SUM ( vCLAIM[Paid] ),
            USERELATIONSHIP ( vCLAIM[Paid Date], DATES[Date] )
        ),
        DateType = "Service Date", CALCULATE (
            SUM ( vCLAIM[Paid] ),
            USERELATIONSHIP ( vCLAIM[Service Date], DATES[Date] )
        ),
        DateType = "Received Date", CALCULATE (
            SUM ( vCLAIM[Paid] ),
            USERELATIONSHIP ( vCLAIM[Received Date], DATES[Date] )
        ),
        DateType = "Entry Date", CALCULATE (
            SUM ( vCLAIM[Paid] ),
            USERELATIONSHIP ( vCLAIM[Entry Date], DATES[Date] )
        ),
        DateType = "Processed Date", CALCULATE (
            SUM ( vCLAIM[Paid] ),
            USERELATIONSHIP ( vCLAIM[Processed Date], DATES[Date] )
        ),
        SUM ( vCLAIM[Paid] )
    )

You can even pull in the 'Date Selection'[Date Type] field into a visual along with your switching mesure and it will calc: