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
Visualizing RATING Score in Power BI
1 hour ago
Calculated Columns vs Measures in DAX
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...
14 hours ago
Unlock the Secrets to Power BI Mastery!
19 hours ago
Can Marthe fix Patrick's Power BI Report?
20 hours ago
Fabric Copilot to help write DAX queries improvements
This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...
1 day ago
Datamart are dead.
1 day ago