If statement not working

[Rena]

I have a measure that finds the start period (12 months prior to latest date).  Which is returning a value of 53 (we are on month 66 right now).

Start Period =

   LOOKUPVALUE('Fiscal Map'[Period #],

    'Fiscal Map'[Date],

    MAX(

        'LEDS - SQL'[Fiscal_Week])

        )-13

Then I am doing a simple IF to include all periods that are greater than the start period

12 Months = IF([Period #]>[Start Period],"Include","Exclude")

The problems is - everything is "Include" (months 1 - 66) instead of just months 54-66. 

[Period #] is a whole number and [Start Period] is a whole number.

[Rena · Accepted solution]

No clue why this works, but if I switch the formula to this it works just fine...

12 Months =

VAR StartPeriod =

    LOOKUPVALUE('Fiscal Map'[Period #],

    'Fiscal Map'[Date],

    MAX(

        'LEDS - SQL'[Fiscal_Week])

        )

RETURN

    IF([Period #]>(StartPeriod-13) && [Period #]<StartPeriod,

    "Include",

    "Exclude"

    )