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 Update - July 2026
1 day ago
Microsoft Copilot (Microsoft 365): Power BI integration in M365 Copilot
This release enables M365 Copilot to reason over Power BI enterprise data and returns grounded answers directly from Power BI reports and sema...
3 days ago
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
4 days ago
Power BI on a Mac: I Love It
7 days ago
I Put 11 Power BI Secrets to The EXPERT Test
7 days ago
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
9 days ago
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
11 days ago