BT Tools
Calendar
Month view, week numbers, day of year.
Clock
Analog and digital clock with world times.
Epoch Converter
Unix timestamp to date and back.
Cron Converter
Cron expression to plain English and next run times.
Image to Base64
Encode an image to Base64 or decode Base64 back to an image.
Pick · Drop · Paste
M ⇄ SQL
Convert Power Query M to GoogleSQL (BigQuery), or SQL back to M.
let … in ⇄ SELECT
Date Bucket
Find the week, month, quarter and year a date falls in, now or N units away.
Buckets
Weeks run Sunday to Saturday. Click a row to show it on the calendar; click a date to copy it as yyyy-mm-dd.
Selected bucket
Result date
Today
Power Query M → GoogleSQL (BigQuery)
What it understands
Clauses: SELECT [DISTINCT],
* EXCEPT / * REPLACE, FROM table / subquery, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT / OFFSET, UNION ALL / DISTINCT, WITHJoins: INNER / LEFT / RIGHT / FULL JOIN with
ON a.x = b.y or USING; joined columns are named alias.columnAggregates: COUNT, COUNT(DISTINCT), SUM, AVG, MIN, MAX, STRING_AGG, COUNTIF, ANY_VALUE
Expressions: CASE, IF, IFNULL / COALESCE, IN, BETWEEN, LIKE, CAST / SAFE_CAST, EXTRACT, string, math and date functions (DATE_ADD, DATE_DIFF, DATE_TRUNC, FORMAT_DATE…)
Native query output wraps the SQL as-is. It is also used automatically for window functions, QUALIFY, UNNEST and subqueries inside expressions.
Tables
project.dataset.table become GoogleBigQuery navigation steps; @param becomes a Power Query parameter.What it understands
Sources: GoogleBigQuery.Database / Sql.Database navigation, Value.NativeQuery,
[Query="…"], Odbc.QueryRows: SelectRows, Sort, FirstN, LastN, Skip, Range, Distinct
Columns: Select / Remove / Rename / Reorder / Duplicate, AddColumn, AddIndexColumn, TransformColumns, TransformColumnTypes, ReplaceValue
Shape: Group, NestedJoin + ExpandTableColumn, Join, Combine, Unpivot
Expressions: if / then / else, and / or / not,
??, Text.*, Number.*, Date.*, List.Contains, #date, #datetimeEach step becomes a CTE named after the step. Anything that can't be translated is listed under the output.
Image → Base64
Base64 → Image
Cron expression
Meaning
| Field | Value | Matches |
|---|
Next 10 runs
Syntax
* * * * * minute hour day month weekdays m h d M w 6 fields, seconds first (Spring / Quartz)* any value ? same as *1,15 list 1-5 range*/10 every 10 0-30/5 stepped rangeJAN–DEC SUN–SAT names; weekday 0 and 7 are both Sunday@hourly @daily @weekly @monthly @yearlyWhen both day and weekday are set, it runs if either matches.
Current Unix time
Timestamp → Date
Seconds, milliseconds, microseconds and nanoseconds are detected from the number of digits.