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
Sensitivity Labels in Power BI ✌🏼
7 hours ago
Elevating Data Interaction with Q&A in Power BI
The Q&A visualization in Power BI allows users to explore data and generate insights using natural language queries. Instead of manually b...
3 days ago
Radius Map Filtering in Power BI 🚀
4 days ago
Mastering Data Preparation: Clean, Transform & Load in Power BI
In Power BI, Clean, Transform & Load (CTL) refers to the process of preparing data before using it for analysis and visualization. This pr...
5 days ago