How can we create a calculated field to show data for the last week and the current week with Monday as the Start date and Sunday being the end date

here is one way

this datetrunc('week',[Order Date],"monday") will create a monday start week and return this when used with a date range filter