Week in Power Query

Hi AllanBerces - you can add a current week column in tables as below:

Date.WeekOfYear(DateTime.LocalNow())

This will give you the current week number.

Add a column to calculate the "Relative Week" by subtracting the WeekN column from the current week number:

WeekN=Date.WeekOfYear([Date])

Relative Week= [Current Week] - [WeekN]

This will create a column where:
0 represents the current week.
-1 represents the previous week.
-2 represents the week before that.
Filter Rows:

Apply a filter to the "Relative Week" column to include only rows where the value is -1 or -2.

After applying this query, your table will only display the relevant weeks (e.g., Week 47 and 46 if the current week is 48).

Hope it works .