Powerquery – only pull data from weeks that have fully ended

Hi all,

I’m importing a table with sales data using powerquery. That sales data has a delay of roughly two weeks, and it’s updated and coming in every day. It looks somewhat like this:

As it’s a lot of data and I only need to have it by week, I’m using the group by function in Powerquery to group these dates into weeks:

This model runs every day. The problem I’m facing is that the last week might only cover a couple of days. I would like to know how I can add a column in Powerquery that shows me whether the week was finished, so that I can filter out all the sales from the week that has not yet finished:

How can I create such a column / formula in powerquery?

best regards

Bas