S:\Business Office\Business Analyst\Traction Rec Data\Active Membership Export.xlsx export Active Members 171042924_Sheet export 171042924 Sheet Promoted Headers export 171042924_Sheet Changed Type UID MID Full Name Type DOB Counts Towards Units Home Branch Discount Recurring Bill Email Gender Last Check-In Date ImageURI Created FirstName MiddleName LastName NickName Barcode MaritalStatus Race BirthDate Age HomeAddress HomeAddressLine2 HomeCity HomeState HomeZip PrimaryPhone AltPhone EmergencyPhone EmergencyContact CorporateID HealthPlanID Employer JobTitle BusinessAddress BusinessAddressLine2 BusinessCity BusinessState BusinessZip BusinessPhone AssociationEmployee Donor Volunteer BoardMember CampaignVolunteer CampaignProspect ReferralType HouseholdIncome YearsInCommunity HealthNeeds HomeOwner Interests VolunteerInterests BillingCycle Payment Type PrimaryMemberFirstName PrimaryMemberLastName PrimaryMemberBirthdate PrimaryMemberEmail PrimaryMemberAge Removed Columns Counts Units Filtered Rows Youth (2 Max) )) Columns1 Home Columns1 monthly Rows1 Payment }) # Table.NestedJoin(# { }# } JoinKind.LeftOuter) # Table.ExpandTableColumn(# Discount Expires NextBillDate Discount Amount Total Amount Expanded 171 Full Queries1 Reordered Columns export 171 Unit ID export 1 { } Date.1 Expanded 1 Termination } { }}) Table.ReorderColumns(# all Table.RemoveColumns(# Removed Columns3 Total }}) Columns1 # Table.ReplaceValue(# #date(2024 4 12)#date(2024 1)Replacer.ReplaceValue{ }) Value1 Replaced Value Value1 Value2 Value3 Value4 Value5 Value6 Value7 Value8 Value9 Value10 Value11 Value12 Value13 Sorted Table.Sort(# {{ Order.Ascending}}) Value15 Sorted Rows Value15 Two Senior Adult Household (65+) Two Household Value16 Youth (1 Max) Youth Value17 Adult (26-64) Adult Value18 Senior (65+) Senior Value19 Young (18-25) Young Adult Duplicated Column Replaced Value20 Type - Copy Replacer.ReplaceText{ }) Value22 Replaced Value22 Table.RenameColumns(# Category Table.AddColumn(# ) Custom1 Added Custom Start_Date 1/1/2020 Table.ReorderColumns(# Custom2 Reordered Columns4 Location Dahl Family YMCA Custom2 End_Date Table.AddIndexColumn(# 1 1) Columns6 Prefix Reordered Columns6 Index MM en-US Added Prefix #date(2024 18)#date(2024 5 Value25 #date(2024 21)#date(2024 Value26 #date(2024 27)#date(2024 Value27 #date(2024 6 Value28 #date(2024 Value29 #date(2024 Value30 #date(2024 Value31 #date(2024 Value32 #date(2024 Value33 #date(2024 Value34 #date(2024 7 Value35 #date(2024 Value36 #date(2024 Value37 #date(2024 Value38 #date(2024 22)#date(2024 Value39 #date(2024 24)#date(2024 Value40 #date(2024 8 Value41 #date(2024 Value42 #date(2024 Value43 #date(2024 Value44 #date(2024 23)#date(2024 Value45 #date(2024 Value46 #date(2024 29)#date(2024 Value47 #date(2024 9 Value48 #date(2024 26)#date(2024 Value49 #date(2024 10 Value50 #date(2024 Value51 #date(2024 20)#date(2024 Value52 #date(2024 Value53 #date(2024 11 Value54 #date(2024 Value55 #date(2024 12 Value56 #date(2024 Value57 #date(2024 15)#date(2025 Value58 #date(2024 26)#date(2025 Value59 #date(2024 27)#date(2025 Value60 #date(2025 2)#date(2025 2 Value61 #date(2025 3)#date(2025 Value62 #date(2025 6)#date(2025 Value63 #date(2025 12)#date(2025 Value64 #date(2025 Value65 #date(2025 20)#date(2025 Value66 #date(2025 25)#date(2025 Value67 #date(2025 Value68 #date(2025 Value69 #date(2025 Value70 #date(2025 21)#date(2025 Value71 #date(2025 # Table.TransformColumns(# Date.EndOfMonth date}}) Custom3 Calculated Month Months ((End_Date-NextBillDate)/7)/4) Rows2 Added Custom3 Extracted Text Before Delimiter Filtered Rows2 Months Text.BeforeDelimiter(Text.From(_ ) Type1 Extracted Delimiter Months Errors Changed Type1 let Source = Excel.Workbook(File.Contents() null true) # Source{Item=Kind=}Data Table.PromoteHeaders(# PromoteAllScalars=true) Table.TransformColumnTypes(#{{ Int64.Type} { type text} number} datetime} date} any} Int64.Type}}) Table.RemoveColumns(#{ }) Table.SelectRows(# each (Type <> and Type (3 Max) Table.RemoveColumns(#{EmailGenderLast Rows1 (BillingCycle )) Columns2{ PrimaryMemberFirstNamePrimaryMemberLastNamePrimaryMemberBirthdatePrimaryMemberEmailPrimaryMemberAgeDiscountRecurring BillMerged QueriesRemoved Columns2MIDexport Current active units 171PrimaryMemberIDexport 171Expanded export 171Merged Queriesexport 171Termination Member Pays Subsidy AmountReordered Table.ReorderColumns(#{ Table.NestedJoin(#{}#{} Queries1Termination Expires Expires.1Renamed Table.RenameColumns(#{{Term date allDiscount Expires.1discount expires allRenamed ColumnsUID Columns3Reordered Columns1discount Table.RenameColumns(#{{Monthly Amount to bill{ billReplaced ValueReordered Columns2NextBillDate Table.ReplaceValue(##date(2024 7)#date(2024 Value2#date(2024 6)#date(2024 Value3#date(2024 5)#date(2024 Value4#date(2024 3 15)#date(2024 Value5#date(2024 9)#date(2024 Value6#date(2024 4)#date(2024 Value7#date(2024 2)#date(2024 Value8#date(2024 14)#date(2024 Value9#date(2024 13)#date(2024 Value10#date(2024 Value11#date(2024 3)#date(2024 Value12#date(2024 11)#date(2024 Value13#date(2024 10)#date(2024 Value14#date(2024 25)#date(2024 #Replaced Value14NextBillDate 8)#date(2024 Value16Replacer.ReplaceText{}) Value17Replacer.ReplaceText{}) Value18Replacer.ReplaceText{}) Value19Replacer.ReplaceText{}) Value20Replacer.ReplaceText{}) Table.DuplicateColumn(# ) Value21Duplicated ColumnTwo HouseholdSeniorType Copy Value21Two HouseholdAdultType CopyReordered Columns3Type }}) Value23Renamed Columns2Young AdultAdultCategoryAdded CustomReplaced Value23Membership_StatusActive Table.AddColumn(# Columns4Added Custom1UIDCategory Columns5{ Columns5Term IndexRenamed Columns3Index IndexUIDEnd_Date Table.TransformColumns(# {{ & Text.From(_ text}}) Table.RemoveColumns(#{}) Value24Removed Columns4 Value24 Value25 Value26 Value27 Value28 Value29 Value30 Value31 Value32 Value33 Value34 Value35 Value36 Value37 Value38 Value39 Value40 Value41 Value42 Value43 Value44 Value45 Value46 Value47 Value48 Value49 Value50 Value51 Value52 Value53 Value54 Value55 Value56 Value57 Value58 Value59 Value60 Value61 Value62 Value63 Value64 Value65 Value66 Value67 Value68 Value69 Value70Calculated End of MonthReplaced Value71End_Date (NextBillDate null)) {{. Table.TransformColumnTypes(#{{ Table.ReplaceErrorValues(# null}}) in