by Jason Cockington | Jul 29, 2026 | Excelerator BI
One of the most rewarding parts of working with DAX is discovering that two measures can return exactly the same result while taking very different paths through the engine. To the report user, there is no difference. The number is correct, the visual renders, and the...
by Jason Cockington | Jun 30, 2026 | Excelerator BI
Level: Beginners Original Post: November, 2016 It was only a few months after Power BI was born, that Matt first posted on this topic. At that time, his focus was still primarily on Power Pivot in Excel, as Power BI was still in its infancy. Despite this,...
by Jason Cockington | May 21, 2026 | Excelerator BI
Why Star Schema Matters More Than Ever in the Age of AI It was over a decade ago that Matt first posted on The Optimal Shape for Power BI Data. Throughout the years since, Matt consistently promoted this as one of the most important lessons he taught Power BI users...
by Jason Cockington | Jul 22, 2025 | Excelerator BI
Level: Beginners Power BI has evolved significantly since Matt’s original publication of this article in 2016. While the foundational concepts remain relevant, modern features and best practices offer more secure, scalable, and collaborative ways to share content....
by Jason Cockington | May 8, 2025 | Excelerator BI
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 when he wrote the blog post 5 common mistakes of self taught DAX students at PowerPivotPro.com. Since then Matt expanded his...
by Matt Allington | Jul 15, 2024 | Excelerator BI
Today I’m going to share my solution to a question I found on the MrExcel forum. It’s an interesting problem. https://www.mrexcel.com/board/threads/power-query-to-determine-consecutive-and-non-consecutive-dates.1261496/ Let me briefly explain the problem. The Problem...
