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) [...]
Published on:
Learn moreRelated posts
Power BI Demo - Full Semantic Model with TMDL?!?
22 hours ago
Power BI Update - April 2025
22 hours ago
Dynamic Pareto analysis in Power BI
1 day ago
Image Slicer in Power BI
2 days ago
Deep dive into Direct Lake on OneLake and creating Direct Lake semantic models in Power BI Desktop
Microsoft Fabric’s OneLake data can be visualized and analyzed in Power BI without moving any data using the new Direct Lake storage mode. . P...
2 days ago
Memory Overhead Of Distinct Count Measures In Power BI
The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This que...
3 days ago