Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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.
User | Count |
---|---|
21 | |
20 | |
13 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |