SELECTCOLUMN WITH YTD Measure not working

[Anonymous]

Hi all, I have one YTD measure as below in one of table name fact_data

Forecast_YTD = 
    Calculate(
        SUM('fact_data'[sale]), 
        FILTER(
            ALL('Date'),
            (
                'Date'[DATE]<=MAX('Date'[DATE])
                && 'Date'[YEAR] = MAX('Date'[YEAR])
            
            )
        )
    )

i would like to have another table using selectcolumn using measure below but the YTD value is not correct. Anyone can help me?

Table_2 =

SELECTCOLUMNS(fact_data', "Date", 'fact_data'[Date], "YTD",  [Forecast_YTD])

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please try using Date table inside SELECTCOLUMNS DAX function.

Table_2 =
SELECTCOLUMNS ( 'Date', "Date", 'Date'[Date], "YTD", [Forecast_YTD] )