Filter Data from last/recent Tuesday

[Nishanth1996]

Hi Everyone,

Can anyone help me, Is there any way in Power Query to filter the table on date column from last/recent "Tuesday"?

As per my reqirement, I have to show data from last tueday.

Thanks in advance.

[amitchandak · Accepted solution]

@Nishanth1996 , These two will give you that, use that to filter the data

Date.AddDays(Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 2),-7)

Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 1)