Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 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!

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi Anonymous 

     

    Add a custom column instead.

     

    =Date.EndOfWeek([PutDateColumnNamehere],0)

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Hi Anonymous 

     

    Add a custom column instead.

     

    =Date.EndOfWeek([PutDateColumnNamehere],0)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.