Table.Group(#"Expanded OnbaseData", {"Family_Ident"},
{{"HHIDStudentTotal", each List.Count(List.Distinct([Student_Number])), Int64.Type},
{"ITSRecipient", each List.First([Technology Subsidy Recipient]), type nullable text},
{"StudentsNames", each Text.Combine([LastFirst]," - "), type nullable text},
{"StudentsIDs", each Text.Combine([Student_Number]," - "), type nullable text},
{"ComputerHolds", each Text.Combine(([Unreturned Computer]," - "), type nullable logical},
{"HotSpotHolds", each Text.Combine(([Hotspot Active]," - "), type nullable logical},
{"AddressHolds", each Text.Combine(([Address Hold])," - ", type nullable logical},
{"HHIDHomeless", each Text.Combine(([U_TRUANCY.HOMELESS]," - "), type nullable text},
{"UnexcusedAbsences", each List.Sum([U_TRUANCY.UNEXCUSED_ABS]), type nullable number},
{"FirstEntryDate", each List.Min([DistrictEntryDate]," - "), type nullable date}})