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...
by Matt Allington | Mar 13, 2024 | Excelerator BI
Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive. For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the […]Read More...
by Nick Jeffries | Mar 4, 2024 | Excelerator BI
Level: Intermediate Why You May Want to use RLS Imagine you’ve just built a Power BI report filled with sensitive financial data. You want to start to share this data across the organisation but not everyone is allowed to see everything. The CFO should be allowed to...
by Matt Allington | Feb 1, 2024 | Excelerator BI
As you may know, Microsoft has an MVP Programme where it acknowledges and rewards community leaders for their subject matter expertise and contribution to the community. There are many benefits of being an MVP including the recognition (leading to people understanding...
by Matt Allington | Dec 2, 2023 | Excelerator BI
Have you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see...
by Matt Allington | Nov 22, 2023 | Excelerator BI
In this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by...
