Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If statement help - inserting a range

Hi all,   I'm looking to add a range to my If statement below, but I'm struggling. Any help would be appreciated!   I need to mark a "1" in a column that contains a number higher than -12 but lo...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    I think this is what you want. Change the signs to >= and <= if you want to include -12 and 0

     

    Measure =
IF(
    'MGA - Complaints (SCANS)'[SRC Difference] > -12
        && 'MGA - Complaints (SCANS)'[SRC Difference] < 0,
    1,
    BLANK()
)

     

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Anonymous 

Give this a try.

SRC sent within 3 day (1/0) = IF('MGA - Complaints (SCANS)'[SRC Difference] >= -12 && 'MGA - Complaints (SCANS)'[SRC Difference] <= 0, 1, blank())