DAX Nested If Bucketing

[Anonymous]

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?

[TomMartens]

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]

can you help why it's being considered wrong?

[amitchandak · Accepted solution]

@Anonymous , true need to use true() ,

Also this code for the new columns not measure. So hope you ar creating a new column