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
DAX User-Defined Functions vs Calculation Groups
14 hours ago
Power BI TMDL Security Roles Done Right
1 day ago
How to Build a Parameterized Environment-Switching Data Source in Power BI for Dataverse (Production-Ready Approach)
In enterprise Power BI reporting, connecting to Dynamics 365 / Dataverse using a fixed environment URL makes deployments fragile. Every time y...
7 days ago
How to create a Power BI Semantic Model online (No need for PBI Desktop)
It has been in the service for quite a while so I thought I would blog about it in terms of how you can create a power BI semantic model simpl...
8 days ago
Power BI Update - March 2026
8 days ago