Mastering Power Query: How to Lift Subtotal Text to Detail Rows for Better Analysis
Use this technique to further analyze subtotaled data
From the Blog
Insights on business intelligence, web development, and turning complex data into actionable solutions.
Use this technique to further analyze subtotaled data
Use ECB Exchange Rates in your Excel / Power Query / Power BI files without downloading the data
Determine Revenue Recognition use a date range and amount
Beyond Spreadsheets: How Modern Businesses Are Streamlining Complex Data Structures
Learn how to make the necessary changes to your Web.Contents function to force Power Query to make a POST, rather than a GET, request
Include data from other sheets when columns are related
Leverage technology in a commercial printshop to yield better results, delight client, and have happier staff
Save keystrokes in Airtable
Custom shipping rates for your Shopify store
Simple reminders using the Google ecosystem and Twilio
View realtime data in your Laravel application
Using Amazon SQS to decouple communications with other software systems
Whether you need to build custom software or automate reporting, I'd love to hear what you're working on.
Book a Free 30-Minute Call