Matt Allington, Author at Excelerator BI

Matt Allington

Matt Allington is the Data Professional you want to be trained by. Matt does a phenomenal job of breaking concepts down into easily digestible chunks. He is also the principal consultant at Excelerator BI Pty Ltd. There are 3 main areas where he can help you save months and even years of self-learning: Kickstart Power BI in your organisation, training and consulting. He also brings his 35-year career expertise in business and data analytics directly to you with his high quality Power BI training courses and consulting. Check out his Public Training and begin your Power BI Ninja journey!

Featuredimage

Finding the Date of the Next Record in Power Query

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 We have the following table, which contains the source data.  Each row contains a unique ID (maybe a piece of equipment) […]

Read More »

Matt

My Journey as Microsoft MVP is Coming to an End

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 that you must be doing something right if Microsoft […]

Read More »

Paginated Reports Button

Build a Power BI Paginated Report Online

Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without having to learn how to use paginated report builder. Sometime since then, Microsoft has released the ability to create a simple paginate report online inside […]

Read More »

PowerPoint Integration with Power BI Visuals

Microsoft has just announced the general availability (GA) of the integration of Power BI with PowerPoint. I have previously blogged about this feature here => Power BI Live Embedding. With the recent GA announcement comes a significant improvement over the public preview version. Power BI Single Visual Embedding in PowerPoint […]

Read More »

Excel

Major Update to Power Pivot

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via […]

Read More »

Scroll to Top