Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Column Date.EndOfWeek

If I create a custom column in Power Query using

= Date.EndOfWeek([DateField)] 

I get the result to be Sunday at 12:00:00 instead of Saturday at 11:59:59 or even Saturday at 12:00:00. For example, the week ending for the most recent week is 1/5/20 12:00:00, Sunday at midnight.

I can create a calculated column to give me the result I want (Desired Result = Custom Column - 1), but that somewhat defeats the purpose of trying to use Power Query.  

Anyone know how I use Power Query to give me Saturday as the week end date?

2 Replies