The Consultants Toolbox - Power Query

This is a Salesforce Power Query tool that is a SOQL editor with sorting, comparison and custom formula capabilities

TCT Power Query is a focused Salesforce SOQL workspace that runs from the Salesforce page you're already signed into — no separate login, no Connected App to set up. Write SOQL with syntax highlighting, validation, and field/object autocomplete pulled live from your org Add local "test formula" columns (Salesforce-style formulas) to see calculated values without changing any Salesforce metadata Filter, sort, compare columns, and add quick summaries (SUM/AVG/MEDIAN/COUNTIF, etc.) over your results Save queries to a personal library, or copy/paste a query to share it with a teammate Export results to CSV or copy them straight into Excel Power Query reuses the Salesforce session from the browser tab that launched it — it never asks for a separate username/password/token, and it never sends your data anywhere except your own Salesforce org. added additional support to 43 total Salesforce formula function. Not Supported: ISNEW, ISCLONE, PRIORVALUE, ISCHANGED, VLOOKUP, GETSESSIONID, CURRENCYRATE, GEOLOCATION, PARENTGROUPVAL supported: Date/time: ADDMONTHS, DATETIMEVALUE, TIMEVALUE, TIMENOW, HOUR, MINUTE, SECOND, MILLISECOND, WEEKDAY, DAYOFYEAR, ISOWEEK, ISOYEAR, UNIXTIMESTAMP, FROMUNIXTIME, FORMATDURATION Math: ACOS, ASIN, ATAN, ATAN2, COS, SIN, TAN, LN, LOG, SQRT, EXP, PI, TRUNC, MCEILING, MFLOOR, CHR Text: ASCII, INITCAP, LPAD, RPAD, REVERSE, URLENCODE, HTMLENCODE, JSENCODE, INCLUDES, BR Logical: ISNULL, ISNUMBER