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" ELSE...
Anonymous , true need to use true() ,
Also this code for the new columns not measure. So hope you ar creating a new column
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
can you help why it's being considered wrong?
Anonymous , true need to use true() ,
Also this code for the new columns not measure. So hope you ar creating a new column