Forum Discussion
Solved
Last friday date and time
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...
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))...
Hi,
That is exactly what i need thank you 😊