Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
5 years ago
Solved

Last Friday date

Hi,   How can I get last Friday date in a Custom Column of Power Query please?   Today is 28/07/2021 so last Friday date was 23/07/2021.   Thanks
Need Help
  • mb0307's avatar
    mb0307
    5 years ago

    Found a solution on Desktop forum:

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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Here is one way to do it in a custom column.

 

= if Date.DayOfWeek([Date]) >= 5 then Date.AddDays(Date.StartOfWeek([Date]), 5) else Date.AddDays(Date.StartOfWeek([Date]), -2)

 

Pat