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

Power BI File Formats Explained: PBIX vs PBIT vs PBIP vs PBIR

Power BI files come in multiple formats. If you have been working with Power BI Desktop for a while, you probably know the PBIX format well. B...

1 day ago

Power BI Tenant Migration: Trade-offs, risks, and realities

Author: Winnie Li, Cloud Solution Architect

2 days ago

The Optimal Shape for Power BI Data

Why Star Schema Matters More Than Ever in the Age of AI It was over a decade ago that Matt first posted on The Optimal Shape for Power BI Data...

2 days ago

New Power Query experience in Power BI Desktop (Preview)

Authored by: Sara Lammini Rodriguez - Product Manager II, and Miguel Escobar - Senior Product Manager

3 days ago

Power BI May 2026 Feature Summary

Author: Katie Murray, Senior Program Manager - Power BI continues to evolve with updates that make it easier to explore data, generate insight...

3 days ago

The Updates and Future of Visualization in Power BI — Interview with Zoe Douglas | Fabric Insider Ep. 2

Fabric Insider Series | Episode 2 | Interview with Zoe Douglas, Feature PM at Microsoft If you have been following Power BI for a wh...

3 days ago

Understanding The “You’ve Exceeded The Capacity Limit For Dataset Refreshes” Error in Power BI

If you have a lot of Power BI semantic models that are scheduled to refresh at the same time in the Service then you may find that some of the...

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