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

Introducing Improvements to the Report Copilot in Power BI

We’ve upgraded the Report Copilot experience in Power BI, making it easier than ever to create, edit, and refine beautiful, data-rich re...

10 hours ago

Power BI October 2025 Feature Summary

This month’s update brings exciting opportunities for learning and community engagement, including the upcoming Fabric Skills Fest and t...

4 days ago

Power BI Report Server September 2025 Feature Summary

PBIRS September 2025 Feature Summary

5 days ago

Automating Power BI Semantic Model Security with Fabric Semantic Link

You may be using standardized solutions like Fabric Unified Admin Monitoring (FUAM) or any other templated solution that comes with a semantic...

6 days ago

First Look At Fabric Graph: Analysing Power BI Import Mode Refresh Job Graphs

The new Fabric Graph database is now rolling out now and should be available to everyone within the next few weeks if you can’t see it a...

8 days ago

Empowering our customers to shape the future of data connectivity in Power BI and Microsoft Fabric

Discover how Microsoft is transforming data connectivity in Power BI and Microsoft Fabric with a community-driven approach. Learn how you can ...

10 days ago

Understanding Power BI Totals: The Math, the Model, and the Misconceptions

The long-running debate around how Power BI calculates totals in tables and matrices has been part of the community conversation for years. Gr...

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