Comparison between last week's status and this week

Hello @Hesham I am looking at your date table and I would suggest loading Melissa’s DateTable from the forum first.

The date table includes IsPreviousWeek and IsCurrentWeek. Then you can write either a dax measure or filter using one or the other. I have downloaded you pbix file and will take a look.

Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum