Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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))
...
Hi,
That is exactly what i need thank you 😊
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))
...