Power Query Dax Code- My cheater code for Grouping by

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}})

Blog Type: