Like for Like comparison

Hi,

Thanks for the solution Dangar332  and Greg_Deckler  offered, and i want to offer some more infotmation for user to refer to.

hello ZakyQadir , you can refer to the following sample.

sample data is the same as you privded, i create a calendar table, and create relationship among tables.

Create the following measures.

Sales = SUM(Sales[Sales])

StartofMonth =
VAR a =
    MAX ( 'List Data'[OpenDate] )
VAR b =
    EOMONTH ( a, -1 ) + 1
VAR c =
    EOMONTH ( a, 0 ) + 1
RETURN
    IF ( [Sales] <> BLANK (), IF ( b = a, b, c ) )

TY LFL Sales =
VAR a =
    EDATE ( [StartofMonth], 12 )
VAR b =
    MAX ( 'Calendar'[Date] )
RETURN
    IF (
        OR (
            YEAR ( b ) = YEAR ( [StartofMonth] )
                && b >= [StartofMonth],
            YEAR ( b ) = YEAR ( a )
                && b >= a
        ),
        [Sales]
    )

LY LFL Sales = IF([TY LFL Sales]<>BLANK(),CALCULATE([Sales],SAMEPERIODLASTYEAR('Calendar'[Date])))

% LFL = DIVIDE([TY LFL Sales]-[LY LFL Sales],[LY LFL Sales])

Then put the measures to the visual.

Best Regards!

Yolo Zhu

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

Output