YTD example

Hi davaru,

If the date slicer is set to "Between", and the date column is dragged from calendar table, you can refer to below formulas.

Dates =
CALENDAR ( MIN ( Capacity[date] ), MAX ( Capacity[date] ) )

YTD Capacity =
CALCULATE (
    TOTALYTD ( SUM ( 'Capacity'[capacity] ), 'Dates'[Date] ),
    ALL ( 'Dates' ),
    FILTER (
        'Capacity',
        'Capacity'[idemployee] < 30000
            && 'Capacity'[functional_type] = "Consulting"
    )
)

LY YTD Capacity =
CALCULATE ( [YTD Capacity Hours], SAMEPERIODLASTYEAR ( Dates[Date] ) )

However, if the date slicer is set to "List", you need an extra calendar table. You should drag date column from 'Dates2'.

YTD =
CALCULATE (
    SUM ( Capacity[capacity] ),
    DATESYTD ( Dates[Date] ),
    FILTER (
        Capacity,
        Capacity[idemployee] < 30000
            && Capacity[functional_type] = "Consulting"
            && Capacity[date] <= MAX ( Dates2[Date] )
    )
)

YTD LY =
CALCULATE (
    [YTD],
    SAMEPERIODLASTYEAR (
        INTERSECT (
            VALUES ( Dates[Date] ),
            DATESBETWEEN ( Dates[Date], BLANK (), MAX ( Dates2[Date] ) )
        )
    )
)

Best regards,
Yuliana Gu