Forum Discussion

Rena's avatar
Rena
Resolver II
1 year ago
Solved

If statement not working

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'[Perio...
Need Help
  • Rena's avatar
    Rena
    1 year ago

    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"
        )
     
     
Rena's avatar
Rena
Resolver II
1 year ago

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"
    )