Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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?

1 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

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

Laedays_0-1628748094037.png

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.