Cumulative total over 2 years

Hi pawelj795 ,

First, one step in the above formula was complicated by me. I have modified it. Please check:

YTD Revenues 5 = 
VAR LastYearFirstDate =
    IF (
        SELECTEDVALUE ( 'Calendar'[Year] ) = BLANK (),
        DATE ( YEAR ( LASTDATE ( Invent_Trans[Date] ) ) - 1, 1, 1 ),
        DATE ( SELECTEDVALUE ( 'Calendar'[Year] ) - 1, 1, 1 ) -------------changed
    )
VAR CurrentDate =
    IF (
        SELECTEDVALUE ( 'Calendar'[Year] ) = BLANK (),
        MAX ( DimDates[Date] ),
        CALCULATE (
            MAX ( DimDates[Date] ),
            FILTER ( DimDates, DimDates[Year] = SELECTEDVALUE ( 'Calendar'[Year] ) )
        )
    )
RETURN
    CALCULATE (
        SUM ( Invent_Trans[Inventory Value] ),
        FILTER (
            ALLSELECTED ( DimDates ),
            DimDates[Date] >= LastYearFirstDate
                && DimDates[Date] <= CurrentDate
        )
    )

Then, you can create your YearWeek column like so:

YearWeek =
CONCATENATE (
    Invent_Trans[Year],
    CONCATENATE ( "  ", FORMAT ( Invent_Trans[WeekNum], "00" ) )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.