Change All Dates To Fridays in a Fri-Thu Week in Power Query

[ExcelAtEverything]

Hello,
I was wondering if anyone could help me with what is probably a very simple tweak. This currently takes a copy of my date column and changes all the dates to Sunday's date of whatever week that is.
The trouble is that my weeks run Fri-Thu, so I need it to show the date of the Friday at the start of each week, not Sunday..
Thx for any help!

= Table.TransformColumns(#"Duplicated Column",{{"Date - Copy", Date.StartOfWeek, type date}})

 

[JGordon11]

= Table.TransformColumns(#"Duplicated Column",{{"Date - Copy", each Date.StartOfWeek(_, Day.Friday), type date}})

 

[juxwillx]

= Table.TransformColumns(#"Duplicated Column",{{"Date - Copy", each Date.StartOfWeek(_, Day.Friday), type date}})

This doesn't work for me. did it work for you @ExcelAtEverything ?

 

[ExcelAtEverything]

= Table.TransformColumns(#"Duplicated Column",{{"Date - Copy", each Date.StartOfWeek(_, Day.Friday), type date}})

I'm going to try coy/pasting it in and see, but this looks identical to what I was trying which is why I was confused when it didn't work. Maybe I had a character off or something. I'll try again and report back.

 

[juxwillx]

I'm going to try coy/pasting it in and see, but this looks identical to what I was trying which is why I was confused when it didn't work. Maybe I had a character off or something. I'll try again and report back.

Any update on this?

 

[RoryA]

It works for me (XL2016). What exactly is happening for you?

 

[ExcelAtEverything]

Sorry it took me so long. I moved on to other work & by the time I got back to this, I redesigned a few things which changed my needs. Finally today I made some time to check back in here & came across my post like "oh yeah", but unfortunately I already changed my sheet. RoryA, should I just assume it works and mark complete? Or should I wait for someone to confirm it works and then mark as complete?

 

[GraH]

The formula given by @JGordon11 is different then yours, and indeed works.
Look at the extra argument in the formula that indicates first day of week as Friday.

Day.Friday