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

How to Access a Former Employee’s Power BI “My Workspace” and Recover Reports

One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal M...

35 minutes ago

Bringing Context Aware Intelligence to Power BI

Ten years ago, Power BI entered the market and transformed how businesses interact with data. Before self-service BI, business users waited da...

1 day ago

Power BI November 2025 Feature Summary

The November 2025 Power BI feature update brings several important announcements and enhancements across the platform. Key highlights include ...

1 day ago

PBIR will become the default Power BI Report Format – Get Ready for the Transition

Starting in January 2026, all new reports created in both Power BI Service and Desktop will use the PBIR format by default, and existing repor...

2 days ago

Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App

A few weeks ago I wrote a blog post about how you can now link event data from Workspace Monitoring to data in the Fabric Capacity Metrics App...

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