How to set week end day in Power Query

[Anonymous]

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 ending on Saturday's and I need it to end on Sunday's.  How do I change the 'day' used for the week end date?

Thank you!

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

Add a custom column instead.

=Date.EndOfWeek([PutDateColumnNamehere],0)

[schwinnen]

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.

[Anonymous]

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.