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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
KayCon
Frequent Visitor

Switch Command on ages help needed

Morning 

 

I am trying to work out specific need depending on ages of children in each household. (bedroom requirements) Each person is on a seperate row with Family Ref linking them together, I need to work out the number of additional bedrooms depending on the following....

 

Opposite sex can share up until age of 10
Same sex can share up until age of 16
Anyone over 16 is entitled to their own bedroom.

 

I have the following columns to use 

  • Family Ref No.
  • Name
  • Type (Mother,Father,Son,Daughter)
  • DOB
  • Age (calulated from DOB)
  • Max Age of Family
  • Min Age of Family 
  • Type2 (Adult/Child)
  • No of People in Family

Idealing I am looking for an output to show who needs 2 beds, 3 beds ect... I've used Switch before but not is this complexity.

 

Any advice would be apprieated.

1 REPLY 1
FreemanZ
Super User
Super User

hi @KayCon ,

 

try to post some sample data, ideally with expected result.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors