Forum Discussion
Filter Data from last/recent Tuesday
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.
Anonymous , 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)
1 Reply
- amitchandak
Super User
Anonymous , 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)