"Moving Metrics" + Date Operations in MBQL

Hi @lvgiacomin
I'm unsure what exactly you are asking for, but you can use relative date filters in Metrics. Or even more advanced custom expressions like How to set date range for comparing this year and last year (to date)
Though, note you might hit this if you're using multiple Metrics:
https://github.com/metabase/metabase/issues/25455 - upvote by clicking :+1: on the first post