Forum Discussion

achristopherson's avatar
achristopherson
Frequent Visitor
6 years ago
Solved

Group age by bracket direct query

I have a dataset with names and ages. I need to show three age groups: Under 18, 18-64, 65 and above. Can someone give me some pointers for setting this up? It seems like it should be relatively simp...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi achristopherson ,

     

    You can create a column:

     

    Column = 
SWITCH(
    TRUE(),
    FamilyMember[Age] < 18, "1) Under 18",
    FamilyMember[Age] >= 18 && FamilyMember[Age] < 65, "2)18 -65",
    "3) Over 65"
)

     

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Try:

 

AgeGroups = 
  SWITCH(TRUE(),
    FamilyMember[Age] < 18, "1) Under 18",
    FamilyMember[Age] >= 65,"3) Over 65",
    "2)18 -65"
  )