SAMEPERIODLASTYEAR \ DATESytd for multiply years

NewbieJono 

ok, Please change the highlighte part into MIN('DIM - Date Table'[Year]):

FYTD Measure 2 = 

var var_TodayMonth = MONTH(TODAY())

var var_RelevantYear = 
    IF(
        var_TodayMonth >= 4 && var_TodayMonth <= 12, 
        MIN('DIM - Date Table'[Year]), 
        MAX('DIM - Date Table'[Year])
    )

var var_StartOfCurrentMonth = DATE(var_RelevantYear,var_TodayMonth,1)
var var_EndOfLastMonth = var_StartOfCurrentMonth - 1 

RETURN
CALCULATE(
    CALCULATE(
        sum('FACT - Transactions'[Volume]),
            DATESYTD ('DIM - Date Table'[Date] , "03/31" )
    ),
    'Dim Date'[Date] = var_EndOfLastMonth
 )

worked on my side

Please also consider how my Date table looks like and that in the measure I used the normal year column (jan - dec) while i used in the table visual the deviated year column (apr mar)

Best regards

Michael

-----------------------------------------------------

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

@ me in replies or I'll lose your thread.