Using SQL queries means you get a neat table. You don’t need to understand the ins and outs of SQL to make the best use of BigQuery. This query is courtesy of Chris Green.

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI.