Forum Discussion
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
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
Thank you!
This is exactly what I was trying to do!
There is no option to insert column.
Where do you add colum? I selected date but there is no insert option.
Ok got it---- Here is a picture in case anyone needs :
There is an issue with this.
Look at how the dates for October show:
This actually does not work...
Look at the October dates. It should be from October 29th to November 3rd
