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
Power BI Revolutionizing Every Industry
2 days ago
Myths, Magic, and Copilot for Power BI
In this article, I explain Copilot in Fabric and Copilot in Power BI, walking through what it is, how it works, and three common scenarios wh...
2 days ago
Get Started with Power BI in 2024
3 days ago
Why Power BI developers should care about the Power BI enhanced report format (PBIR)
Power BI's new PBIR format enhances collaboration, version control, and efficiency for developers. Learn key benefits and future implications.
3 days ago
Power Automate – Enable application lifecycle management for customized process mining Power BI reports
The ALM (Application Lifecycle Management) feature for customized process mining Power BI reports is now generally available. With this featur...
5 days ago
Power BI - How to Mass filter your data
5 days ago