SAMEPERIODLASTYEAR over multiple years

HI Anonymous,

First, stacked/clustered column charts not support secondary y axis, current line and stacked column chart/clustered column charts support secondary y axis which can only used with line value field.

Second, when you enable legend on stacked/clustered column charts, it is impossible to use multiple value fields. You can only display current year or previous year values base on date column.

Sample measure formulas to create different visuals:

Current=
CALCULATE (
    SUM ( Table[Amount] ),
    VALUES ( Table[Date] ) 
)


Previous Year=
CALCULATE (
    SUM ( Table[Amount] ),
    SAMEPERIODLASTYEAR ( VALUES ( Table[Date] ) )
)

Notice: dax time intelligence functions are fixed and not support apply on complex filters and advanced customize, if your scenario is over their limit, please try to use date function with filters to manually coding conditions and point out date range.

Regards,

Xiaoxin Sheng