Friendly Week Names

Hi lcasey

In Queries Editor,

Add custom columns

weeknum=Date.WeekOfYear([date], Day.Monday)

start of week=Date.StartOfWeek([date], Day.Monday)

end of week=Date.EndOfWeek([date], Day.Monday)

Click on column [date] column, select "Add column"->Date, insert "Name of Month"

Click on column [start of week] column, select "Add column"->Date, insert "Day"

Click on column [end of week] column, select "Add column"->Date, insert "Day"

Click on column [Month Name] and [Day], select "Add column"->"Merge columns"  (separator:space)

Click on column [Month Name] and [Day.1], select "Add column"->"Merge columns"  (separator:space)

Add a custom column

Custom=Text.Combine({"From", [Merged],"to",[Merged.1]}, " ")

Then ypu could remove other columns, only keep the last column

Best Regards

Maggie