M (PowerQuery) query for querying members of AD Groups

ADGroupsMembers

let
    Source = ActiveDirectory.Domains("domain.com"),
    #"euser eroot eadidom com" = Source{[Domain="domain.com"]}[Object Categories],
    group1 = #"euser eroot eadidom com"{[Category="group"]}[Objects],
    #"Expanded securityPrincipal" = Table.ExpandRecordColumn(group1, "securityPrincipal", {"sAMAccountName"}, {"securityPrincipal.sAMAccountName"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded securityPrincipal", each Text.StartsWith([securityPrincipal.sAMAccountName], "GROUPNAME")),
    #"Expanded group" = Table.ExpandRecordColumn(#"Filtered Rows", "group", {"member"}, {"group.member"}),
    #"Expanded group.member" = Table.ExpandListColumn(#"Expanded group", "group.member"),
    #"Expanded user" = Table.ExpandRecordColumn(#"Expanded group.member", "group.member", {"mail"}, {"Email Address"}),
    #"Filtered Rows1" = Table.SelectRows(#"Expanded user", each [Email Address] <> null),
    #"Renamed Columns" = Table.RenameColumns(#"Filtered Rows1",{{"securityPrincipal.sAMAccountName", "Security Group"}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Email Address", "Security Group"})
in
    #"Removed Other Columns"