Blog

Learn two methods for aggregating data from multiple tables based on selection criteria in Power Query, using Table.SelectRows and Table.NestedJoin.

Learn how to use Power Query to retrieve corresponding values based on date ranges, ideal for various time-based data transformations in Excel.

Learn how to convert UTC to Eastern Time in Power BI with a custom Power Query function that accounts for daylight saving time.

Handling decimal rounding in Java with BigDecimal to avoid round-off errors and ensure precise calculations for critical applications.

Learn how to display the last updated date for an Excel file in Power BI using Excel VBA or Power Query, with step-by-step instructions for both methods.

Learn how to define named values in Excel and create a reusable Power Query function to easily retrieve those named values in your queries.

Learn how to add JSON-LD structured data to your Astro website to enhance search engine understanding, improve visibility, and enable rich search results.

Step-by-step guide to create a dynamic timestamp displaying the latest semantic model refresh date in Power BI.

Learn how to install self-signed S/MIME certificates on iOS, enable encrypted email in the Mail app, and secure your digital communications.

Learn how to use Power BI what-if analysis and modeling parameters to create interactive reports and gain insight into how decisions affect outcomes.

The steps attempted to recover data from a failed microSD Card, what worked, what did not, and the important lessons learned.

Explore whether old floppy disks, like 3.5-inch and 8-inch, are truly secure for data storage. Learn about data recovery, obsolescence, and access challenges.

Discover how switching to Markdown simplified content creation, improved focus on writing, and enhanced portability over WordPress and Gutenberg.

Learn how to use VBA and regular expressions in Excel to easily parse substrings from cell values without complex formulas.

How to create cascading drop-down lists in Excel using data validation and named ranges to improve data accuracy and quality in collaborative workbooks.

Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.

Reflecting on blogging for knowledge sharing and personal growth despite AI challenges and low traffic.

Learn how photo deduplication can help you manage digital clutter, save storage space, and organize your photo library with easy, effective methods.

Learn to manage draft posts in Astro by adding a property to your schema, filtering drafts in production, and keeping them visible in development.

Learn how to add a related posts property to your Astro content collection schema and display related posts links on your blog using custom components.