Date.IsInPreviousNWeeks - force week starting day to Saturday

[mdex]

I have the below simple query to check if the date is in the previous week. Unfortunately this runs Mon-Sun and I'd like to be able to force starting week day to be Saturday if it's possible?

each if Date.IsInPreviousNWeeks([Dates],1)=true then "Yes" else "No")

[mdex · Accepted solution]

Solved this myself by creating another column called Date2 which is Dates - 2!?

Running my query against that column instead.