Custom Column Date.EndOfWeek

[schwinnen]

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?

[ChrisMendoza · Accepted solution]

@schwinnen -

Is this what you're meaning to accomplish?

[schwinnen]

Looks right @ChrisMendoza