Blog
Power Query: Get the Corresponding Value for a Date Within a Date Range
Learn how to use Power Query to retrieve corresponding values based on date ranges, ideal for various time-based data transformations in Excel.
Power BI: Convert UTC to Eastern Time in Power Query with Daylight Saving Adjustments
Learn how to convert UTC to Eastern Time in Power BI, accounting for daylight saving time, with a custom Power Query function for accurate time zone adjustments.
Rounding Decimals in Java: Avoiding Round-Off Errors with BigDecimal
Handling decimal rounding in Java with BigDecimal to avoid round-off errors and ensure precise calculations for critical applications.
How to Display the File Last Updated Date in Power BI Using Excel VBA or Power Query
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.
Power Query: How to Retrieve Excel Defined Name Values
Learn how to define named values in Excel and create a reusable Power Query function to easily retrieve those named values in your queries.
Astro: Add JSON-LD Structured Data to Your Website for Rich Search Results
Learn how to add JSON-LD structured data to your Astro website to enhance search engine understanding, improve visibility, and enable rich search results.
Power BI: Create and Display a Dynamic Last Refreshed Timestamp
Step-by-step guide to create a dynamic timestamp displaying the latest semantic model refresh date in Power BI.
How to Install Self-Signed S/MIME Certificates on iOS and Enable Encrypted E-mail
Learn how to install self-signed S/MIME certificates on iOS, enable encrypted email in the Mail app, and secure your digital communications.
Power BI What-If Analysis: Create Interactive Reports Using Modeling Parameters
Learn how to use Power BI’s what-if analysis and modeling parameters to create interactive reports and gain insight into how decisions affect outcomes.
Dealing with a Complete Storage Failure
The steps attempted to recover data from a failed microSD Card, what worked, what didn’t, and the important lessons learned.
Security through Obsolescence: Are Old Floppy Disks Secure?
Explore whether old floppy disks, like 3½-inch and 8-inch, are truly secure for data storage. Learn about data recovery, obsolescence, and access challenges.
Switching from Gutenberg to Markdown: A More Efficient Writing Experience
Discover how switching to Markdown simplified content creation, improved focus on writing, and enhanced portability over WordPress and Gutenberg.
How to Use Regular Expressions in Excel for Parsing Substrings with VBA
Learn how to use VBA and regular expressions in Excel to easily parse substrings from cell values without complex formulas.
Excel: Create Cascading Drop-Down Lists for Better Data Validation and Quality Control
How to create cascading drop-down lists in Excel using data validation and named ranges to improve data accuracy and quality in collaborative workbooks.
Power BI Slicer for Multi-Value Columns: Splitting Delimited Data for Better Filtering
Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.