Help with comparting data dates

Hi Anonymous

The formula in your lastest post is correct to solve this problem.

So far, it is a useful workaround for your problem.

The penultimate one shows a incorrect formula.

MinDate =
CALCULATE (
 MIN ( 'Table'[Full Date] ),
 FILTER ( 'Table', 'Table'[Measure Version] = "Actual" ),
 FILTER ( 'Table', 'Table'[Full Date] = YEAR ( 2018 ) )  //incorrect 
)

Please see reference how to use "calculate" with "filter"

https://www.sqlbi.com/articles/filter-arguments-in-calculate/

If the formula is used in a measure, you could use the following instead.

YTD Plan =
VAR TableMaxDate =
    CALCULATE (
        MAX ( 'Table'[Full Date] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Measure Version] = "Actual" )
    )
VAR MinDate =
    CALCULATE (
        MIN ( 'Table'[Full Date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Measure Version] = "Actual"
                && YEAR ( 'Table'[Full Date] ) = 2018  //from the information, it seems it is no 
                                                         need to add this part, if so, 
                                                         you could delete this part
        )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[GM] ),
        FILTER ( 'Table', 'Table'[Measure Version] = "Plan" ),
        DATESBETWEEN ( DIM_Date[Date], MinDate, TableMaxDate )
    )

Best Regards

Maggie