something like this which is dynamic and will change according time filter(day, week, month, quarter, year)
In Looker, while there isn't a direct option to create calculated measures for previous periods through a properties panel, you can adjust the period using the same variable (e.g., sales) by selecting different timeframes such as 'Current month', 'Current year', 'Last year', and others