The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
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")
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")