I used a if query to create a new column but it gives me a syntax error, could you check the query and assist me.

[kravivarapu]

DEP_GRP = IF(1<'2015_SUMMER_ONTIME'[DEP_DELAY]<=30,0,IF(31<'2015_SUMMER_ONTIME'[DEP_DELAY]<=60,1,IF(61<'2015_SUMMER_ONTIME'[DEP_DELAY]<=100,2,IF(101<'2015_SUMMER_ONTIME'[DEP_DELAY]<=200,3,IF('2015_SUMMER_ONTIME'[DEP_DELAY]>200,4,-1)))))

[chass]

Please post this in the forums Http://community.powerbi.com