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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
asood23
New Member

Error for if statement

Hi Guys,
So I'm fairly new to this and would like some help over here.
For my dataset I created a column Age with randbetween function and values from 10 to 28. So this column is formed correctly. Now I wanted to create another column and divide these ages into groups like 10-12 should be kids, 13-19 should be teens, and rest should be adults.
Normally I would create a conditional column but the section doesnt show the column Age and I'm guessing thats because I used the randbetween function which is ok so I tried to do it by creating a new column by 

Age group = IF('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12,"Kids") & IF('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19,"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")
Still getting some errors.

Any help will be appreciated!
TIA.
1 ACCEPTED SOLUTION
asood23
New Member

Turns out if and, if and and if works perfectly

 

Age group = IF(AND('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12),"Kids") & IF(AND('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19),"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")

View solution in original post

1 REPLY 1
asood23
New Member

Turns out if and, if and and if works perfectly

 

Age group = IF(AND('Sheet1 (2)'[Age]>=10,'Sheet1 (2)'[Age]<=12),"Kids") & IF(AND('Sheet1 (2)'[Age]>12,'Sheet1 (2)'[Age]<=19),"Teens")& IF('Sheet1 (2)'[Age]>=20,"Adults")

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.