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.
Go to 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)
View solution in original post
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.