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

Deep dive into Direct Lake on OneLake and creating Direct Lake semantic models in Power BI Desktop

Microsoft Fabric’s OneLake data can be visualized and analyzed in Power BI without moving any data using the new Direct Lake storage mode. . P...

2 days ago

Memory Overhead Of Distinct Count Measures In Power BI

The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This que...

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