If statement not working

Question

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 Answer

No clue why this works, but if I switch the formula to this it works just fine...&nbsp;12 Months = VAR StartPeriod = &nbsp; &nbsp; LOOKUPVALUE('Fiscal Map'[Period #],&nbsp; &nbsp; 'Fiscal Map'[Date],&nbsp; &nbsp; MAX(&nbsp; &nbsp; &nbsp; &nbsp; 'LEDS - SQL'[Fiscal_Week])&nbsp; &nbsp; &nbsp; &nbsp; )RETURN&nbsp; &nbsp; IF([Period #]&gt;(StartPeriod-13) &amp;&amp; [Period #]&lt;StartPeriod,&nbsp; &nbsp; "Include",&nbsp; &nbsp; "Exclude"&nbsp; &nbsp; )&nbsp;&nbsp;

Forum Discussion

If statement not working

1 Reply

Related content

OR Statement ?

subtotal not work in metrics (value has "if" statement)

Switch Statement Not Working

SQL Statement opcion error

IF statement not working