Relative date sum If not SQL


I'm interested in creating a custom expression using the Editor (not SQL) to sum the data for the last 7 days. Currently, I have the following SumIf expression:

SumIf([nb_ad_sync_load], between([time_scope_value], "2024-01-24", "2024-01-31"))

However, as I'm relatively new to this, I was wondering if it's possible to achieve the same result using a "relative" approach, specifically, for the past 7 days. If you have the expertise to guide me through this, I would greatly appreciate it.

Thank you.