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
Using RANK instead of RANKX in DAX
1 day ago
Deprecating Power BI Q&A
We are announcing the deprecation of Q&A, our legacy natural language tool, which will take place in December 2026. Moving forward, users ...
2 days ago
A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance
Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the ...
3 days ago
Boost Your Dashboards: The Role of Visual Calculations in Power BI
Visual Calculations in Power BI play a transformative role by allowing users to write calculations directly within a visual, simplifying analy...
6 days ago
Fix ANY Date Format in Excel with Copilot Function – no Power Query – no Macros!
Fix ANY Date Format in Excel with Copilot Function without any Macros. Got dates in multiple, different and difficult formats? No problem. ...
6 days ago