Filter by lowest value of week column based on snapshotday column

[Max]

You can look at this post.

Week Numbers (1-53)

Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. dateDiff(truncDate("WK", truncDate('YYYY', {order_date})), {order_date}, 'WK')+1

I would make a calculated field that is an ifelse that says is your week field equal to this field ^. If so return ‘True’ else return ‘False’ and then filter only for trues.