Microsoft’s Power BI supplies a default date table that’s adequate for many time grouping requirements. Find out how to know if the Auto date table is adequate when using Power BI. You can base Power ...

Build multi-table data models with Power Pivot to upgrade your Excel workflow. Replace flat files and use DAX variables for ...

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI. The article How to know if the Auto Date ...

Power Query’s May 2025 update introduced a significant improvement to the `Table.TransformColumnTypes` function, addressing long-standing issues with locale settings and missing field handling.

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

If you spend Mondays copying data from email attachments into a "Master" sheet, you're not working in Excel—you're doing manual labor. Power Query fixes that. Master these three core data ...

Jeff's been involved in the IT industry since before the Internet and spent more than 20 years working in technical support, system administration, network administration, and consulting roles. He ...