Last friday date and time

[Remon1991]

Hi,

How can I get last Friday date and every hour in a Custom Column of Power Query please?

Today is 01/05/2024 so last Friday date was 26/04/2024.

I have a column with date and time with every hour where i much look at.

I now use Date.AddDays(DateTime.From(DateTime.LocalNow()),-Date.DayOfWeek(DateTime.From(DateTime.LocalNow()),5)))

But then it looks at last friday with actual time stamp.

Thanks

[Remon1991]

Hi, 

That is exactly what i need thank you 😊

[ronrsnfld · Accepted solution]

Not sure exactly what you want since you don't show an example of your desired results, and your explanation is not clear to me, but for last friday as a DateTime:

lastFriday = Date.StartOfWeek(DateTime.FixedLocalNow(),Day.Friday)

=> 4/26/2024 12:00:00 AM

And for all the hours of last friday:

   lastFriday = Date.StartOfWeek(DateTime.FixedLocalNow(),Day.Friday),
   AllHours = List.DateTimes(lastFriday,24,#duration(0,1,0,0))

...