You can calculate the values of the Google Analytics 4 Returning Users metric in BigQuery by counting distinct values of user_pseudo_id whose first interaction date occurs before the specified time period but who generated at least one event within the period.
