What is wrong with this Date-Table code?

[Waleed18574]

I used this code to make a DataTable. However, I it retruned an error (token identifier expected)...you may see the attached photos too!

So...any suggestions?

TQ

/* Power Query Code to make date atable
Modify the StartDate and EndDate values as necessary for your data
*/
let
StartDate = #date(2017,01,01),
EndDate = #date(2017,12,31),

//Get the number of the dates that will be required for the table
GetDateCount = Duration.Days(EndDate - StartDate),

//Make the count of the dates and turn into list of dates
GetDateList = List.Dates(StartDate, GetDateCount, #duration(1,0,0,0)),

//Convert the list into table
DateListToTable = Table.FromList(GetDateList, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),

//Add Year Column
YearNumber = Table.AddColumn(DateListToTable, "Year", each Date.Year([Date])),

//Add Quarter Column
QuarterNumber = Table.AddColumn(YearNumber, "Quarter", each "Q" & Number.ToText(Date.QuarterOfYear([Date]))),

//Add Week Number Column and Prefix with 0
WeekNumber = Table.AddColumn(QuarterNumber, "Week Number", each Date.WeekOfYear([Date])),
AddPrefix0ToWeekNo = Table.TransformColumns(WeekNumber, {{"Week Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsWeekNo = Table.SplitColumn(AddPrefix0ToWeekNo, "Week Number", Splitter.SplitTextByPositions({0,2},true)), {"Week Number.1","Week Number.2}),
CleanUpWeek1Column = Table.RemoveColumns(Last2DigitsWeekNo,{"Week Number.1"}),
RenameToWeekNumber = Table.RenameColumns(CleanUpWeek1Column,{{"Week Number.2", "Week Number"}}),

//Add Month Number Column and Prefix with 0
MonthNumber = Table.AddColumn(RenameToWeekNumber, "Month Number", each Date.Month([Date])),
AddPrefix0ToMonthNo = Table.TransformColumns(MonthNumber,{{"Month Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsMonthNo = Table.SplitColumn(AddPrefix0ToMonthNo, "Month Number", Splitter.SplitTextByPositions({0,2},true), {"Month Number.1","Month Number.2}),
CleanUpMonth1Column = Table.RemoveColumns(Last2DigitsMonthNo,{"Month Number.1"}),
RenameToMonthNumber = Table.RenameColumns(CleanUpMonth1Column,{{"Month Number.2", "Month Number"}}),

//Add Month Name Column
MonthName = Table.AddColumn(RenameToMonthNumber, "Month", eaach Date.ToText([Date],"MMMM")),

//Add Day of Week Column
DayOfWeek = Table.AddColumn(MonthName, "Day of Week", each Date.ToText([Date],"ddddd"))

//Add Day of Week Number
CreateDayOfWeekColumn = Table.DuplicateColumn(DayOfWeek, "Date", "Date - Copy"),
#"Calculated Day of Week" = Table.TransformColumns(CreateDayOfWeekColumn,{{"Date - Copy", Date.DayOfWeek, Int64.Type}}),
RenameToDayOfWeekColumn = Table.RenameColumns(#"Calculated Day of Week",{{"Day - Copy", "Day of Week Number"}}),

//Add Day of Month Number and Prefix with 0
CreateDayOfMonthColumn = Table.DuplicateColumn(RenameToDayOfWeekNumber, "Date", "Date - Copy"),
#"Extracted Day" = Table.TransformColumns(CreatDayOfMonthColumn, {{"Date - Copy", Date.Day, Int64.Type}}),
RenameToDayOfMonthColumn = Table.RenameColumns(#"Extracted Day", {{"Date - Copy", "Day of Month Number"}}).
AddPrefix0ToDayOfMonth = Table.TransformColumns(RenameToDayOfMonthColumn, {{"Day of Month Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsDayOfMonth = Table.SplitColumn(AddPrefix0ToDayOfMonth, "Day Of Month number", Splitter.SplitTextByPositions({0,2},true),{"Day of Month number.1","Day of Month number.2"}),
CleanUpDayOfMonth1Column = Table.RemoveColumns(Last2DigitsDayOfMonth,{"Day of Month number.1"}),
RenameDayOfMonthNumber = Table.RenameColumns(CleanUpDayOfMonth1Column,{{"Day of Month number.2","Day of Month number"}})

in
RenameToDayofMonthNumber

[mahoneypat · Accepted solution]

Fixed multiple errors (name references and case errors).

let
StartDate = #date(2017,01,01),
EndDate = #date(2017,12,31),

//Get the number of the dates that will be required for the table
GetDateCount = Duration.Days(EndDate - StartDate),

//Make the count of the dates and turn into list of dates
GetDateList = List.Dates(StartDate, GetDateCount, #duration(1,0,0,0)),

//Convert the list into table
DateListToTable = Table.FromList(GetDateList, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),

//Add Year Column
YearNumber = Table.AddColumn(DateListToTable, "Year", each Date.Year([Date])),

//Add Quarter Column
QuarterNumber = Table.AddColumn(YearNumber, "Quarter", each "Q" & Number.ToText(Date.QuarterOfYear([Date]))),

//Add Week Number Column and Prefix with 0
WeekNumber = Table.AddColumn(QuarterNumber, "Week Number", each Date.WeekOfYear([Date])),
AddPrefix0ToWeekNo = Table.TransformColumns(WeekNumber, {{"Week Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsWeekNo = Table.SplitColumn(AddPrefix0ToWeekNo, "Week Number", Splitter.SplitTextByPositions({0,2},true), {"Week Number.1","Week Number.2"}),
CleanUpWeek1Column = Table.RemoveColumns(Last2DigitsWeekNo,{"Week Number.1"}),
RenameToWeekNumber = Table.RenameColumns(CleanUpWeek1Column,{{"Week Number.2", "Week Number"}}),

//Add Month Number Column and Prefix with 0
MonthNumber = Table.AddColumn(RenameToWeekNumber, "Month Number", each Date.Month([Date])),
AddPrefix0ToMonthNo = Table.TransformColumns(MonthNumber,{{"Month Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsMonthNo = Table.SplitColumn(AddPrefix0ToMonthNo, "Month Number", Splitter.SplitTextByPositions({0,2},true), {"Month Number.1","Month Number.2"}),
CleanUpMonth1Column = Table.RemoveColumns(Last2DigitsMonthNo,{"Month Number.1"}),
RenameToMonthNumber = Table.RenameColumns(CleanUpMonth1Column,{{"Month Number.2", "Month Number"}}),

//Add Month Name Column
MonthName = Table.AddColumn(RenameToMonthNumber, "Month", each Date.ToText([Date],"MMMM")),

//Add Day of Week Column
DayOfWeek = Table.AddColumn(MonthName, "Day of Week", each Date.ToText([Date],"ddddd")),

//Add Day of Week Number
CreateDayOfWeekColumn = Table.DuplicateColumn(DayOfWeek, "Date", "Date - Copy"),
#"Calculated Day of Week" = Table.TransformColumns(CreateDayOfWeekColumn,{{"Date - Copy", Date.DayOfWeek, Int64.Type}}),
RenameToDayOfWeekColumn = Table.RenameColumns(#"Calculated Day of Week",{{"Date - Copy", "Day of Week Number"}}),

//Add Day of Month Number and Prefix with 0
CreateDayOfMonthColumn = Table.DuplicateColumn(RenameToDayOfWeekColumn, "Date", "Date - Copy"),
#"Extracted Day" = Table.TransformColumns(CreateDayOfMonthColumn, {{"Date - Copy", Date.Day, Int64.Type}}),
RenameToDayOfMonthColumn = Table.RenameColumns(#"Extracted Day", {{"Date - Copy", "Day of Month Number"}}),
AddPrefix0ToDayOfMonth = Table.TransformColumns(RenameToDayOfMonthColumn, {{"Day of Month Number", each "0" & Text.From(_,"en-US"), type text}}),
Last2DigitsDayOfMonth = Table.SplitColumn(AddPrefix0ToDayOfMonth, "Day of Month Number", Splitter.SplitTextByPositions({0,2},true),{"Day of Month number.1","Day of Month number.2"}),
CleanUpDayOfMonth1Column = Table.RemoveColumns(Last2DigitsDayOfMonth,{"Day of Month number.1"}),
RenameDayOfMonthNumber = Table.RenameColumns(CleanUpDayOfMonth1Column,{{"Day of Month number.2","Day of Month number"}})

in
RenameDayOfMonthNumber

Pat

[Waleed18574]

Thanks