Forum Discussion
How to set week end day in Power Query
Hello, I am trying to add a column for "week end date" via Power Query. On the Transform Ribbon, I selected Date > Week > End of Week and it added the column. However, it is showing weeks endin...
Hi Anonymous
Add a custom column instead.
=Date.EndOfWeek([PutDateColumnNamehere],0)
Hi Anonymous
Add a custom column instead.
=Date.EndOfWeek([PutDateColumnNamehere],0)
I just found this post because I am looking for a similar solution. This is exactly what I would like to do, but ideally I would want to add this customer column to the Date Table I created. Is it possible to do this? The Date Table is not listed in the Power Query Editor.
Did you add the date table via Power BI desktop? If so, it will not be available for modifications in PowerQuery. You could set the week end date in the table in Power BI desktop, though.