This is my solution to getting a specific period of time I want for example Monthly Active Users (MAU) using BigQuery Syntax:

SELECT dt AS date,
count(distinct(UserId)) AS MAU
FROM Login
WHERE dt >= date_sub(current_date(), interval 30 DAY)

This query will check what was the first date to start counting from 30 days ago and take everything between that date and current date.

1 Like