Add YTD and LYTD calculated column to Table Date

[Anonymous]

Greeting Guys , 

i want to add a 2 calculated column into my Date Table called "ContainInYTD" and "ContainInLYTD" 

This column equals True if the row belong to the YTD and False if not . (Based on the current date)

Exemple : 

since we are in march ,the rows from january to march equals to true the others rows equal to false . is it possible ? 

Thanks all in advance 😊. ( i can explain more if needed ) 

[DataInsights]

@Anonymous,

Try these calculated columns:

ContainInYTD = 
VAR vToday =
    TODAY()
VAR vYear =
    YEAR ( vToday )
VAR vResult =
    IF ( DIM_DATE[DATE] <= vToday && DIM_DATE[YEAR] = vYear, 1, 0 )
RETURN
    vResult

ContainInLYTD = 
VAR vToday =
    TODAY ()
VAR vYear =
    YEAR ( vToday )
VAR vMonth =
    MONTH ( vToday )
VAR vDay =
    DAY ( vToday )
VAR vResult =
    IF (
        DIM_DATE[DATE]
            <= DATE ( vYear - 1, vMonth, vDay )
            && DIM_DATE[YEAR] = vYear - 1,
        1,
        0
    )
RETURN
    vResult