Switch Command on ages help needed

KayCon — Thu, 23 Nov 2023 09:15:41 GMT

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.

Re: Switch Command on ages help needed

FreemanZ — Thu, 23 Nov 2023 12:42:10 GMT

hi KayCon ,

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

topic Re: Switch Command on ages help needed in DAX Commands and Tips

Switch Command on ages help needed

Re: Switch Command on ages help needed