YOY - Year wise comparison

hi Anonymous 

try to plot any visual with year column and a measure like:

YoY% = 
VAR _valuepre = 
    CALCULATE(
        SUM(TableName[Value]),
        TableName[Year] = MAX(TableName[Year])-1
    )
VAR Result =
    DIVIDE(
        SUM(TableName[Value]),
        _valuepre
    )-1

RETURN
    IF(
        _valuepre<>BLANK(),
        Result
    )

it worked like:

p.s. as suggested by joht75, in the long run, you shall be working with dedicated date tables.