Forum Discussion
DAX Nested If Bucketing
Hello Team,
I could not work out the formula into Power BI is there a limitation in the nested ifs?
IF [Days] <30 THEN "<30 Days"
ELSEIF [Days] >= 30 AND [Days] <= 69 THEN "30-69 Days"
ELSEIF [Days] >= 70 AND [Days] <= 100 THEN "70-100 Days"
ELSEIF [Days] >= 101 AND [Days] <= 140 THEN "101-140 Days"
ELSEIF [Days] >= 141 AND [Days] <= 180 THEN "141-180 Days"
ELSE ">180 Days" END
How do i put this in DAX?
Anonymous , true need to use true() ,
Also this code for the new columns not measure. So hope you ar creating a new column
3 Replies
Hey Anonymous ,
there is no limitation in nesting, besides the fact that DAX doesn't know ELSEIF, for this reason you have to use the SWITCH function: SWITCH – DAX Guide
Hopefully, this provides ideas on how to tackle your challenge.
Regards,
Tom
Anonymous , true need to use true() ,
Also this code for the new columns not measure. So hope you ar creating a new column
