replace EndOfYear parameter with column value

Hi meikev ,

 

We can try to use a calculated table and a measure to meet your requirement:

 

Calculated table:

Table = ADDCOLUMNS ( CALENDARAUTO (), "EOY", FORMAT ( [Date], "DD MMM" ) )

 

Measure:

YTD WIP Total Fees =
VAR endDate =
    MAX ( 'Perspectives'[Date] )
VAR startDate =
    CALCULATE ( MAX ( 'Table'[Date] ), 'Table'[Date] <= endDate )
RETURN
    CALCULATE (
        SUM ( 'Perspectives'[WIP Total Fees] ),
        FILTER (
            ALLSELECTED ( 'Perspectives' ),
            'Perspectives'[Date] >= startDate
                && 'Perspectives'[Date] <= endDate
        )
    )

 

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？

By the way, PBIX file as attached.

Best regards,