Loading...

Finding the Date of the Next Record in Power Query

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 »

Published on:

Learn more
Power BI Live Training - Power BI Online Training - Excelerator BI
Power BI Live Training - Power BI Online Training - Excelerator BI

Australian Power BI training ✅ Power BI online training ✅ Learn Power Query online ✅ Power BI expert, Matt Allington (MVP) ✅ Best in class Power BI book

Share post:

Related posts

Prep Your Data for AI — Now in the Power BI Service 

Until now, preparing your data for AI was only possible in Power BI Desktop. That changes today! As of today, we are rolling out the ability f...

14 hours ago

Deprecation of Metric Sets in Power BI

The Metric Sets feature in Power BI will be deprecated, with a phased retirement beginning October 25th, 2025. What’s Changing and When Scorec...

1 day ago

Business Central 2025 wave 2 (BC27): Access open-sourced Power BI apps

Hi, Readers.Dynamics 365 Business Central 2025 wave 2 (BC27) is generally available. More details: General Available: Dynamics 365 Busine...

1 day ago

Snowflake Query Tags In Power BI And Workspace Monitoring

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an ...

2 days ago

How to quickly find rows with errors in Power Query when using Power BI

In the past when there has been an error when loading data into the semantic model, there can be times when clicking on the View errors can ei...

7 days ago

Wave 1 Highlights: What Power Automate & Power BI Offer You This Year

The Microsoft Power Suite has been redefining digital transformation for businesses across industries. Every year, Microsoft introduces fresh ...

13 days ago

Power BI in Teams – Content Shared in Teams Chats Now Opens a Dedicated Separate Window Within Teams

Power BI in Teams – Content Shared in Teams Chats Now Opens a Dedicated Separate Window Within Teams

14 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy