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, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode
This is going to sound strange, but one of the things I like about tuning Power BI DirectQuery semantic models is that their generally-slower ...
14 hours ago
Creating Engaging, Animated Line Charts in Power BI with Custom Visuals
Power BI provides powerful built-in visuals, but sometimes you need custom behavior—such as animated line transitions when filters change. In ...
3 days ago
Generate ERD diagrams for your Power BI Semantic Model using GitHub Copilot
While preparing for a training day I will host early March, I was doing some experiments in VS Code with GitHub Copilot and a few related exte...
5 days ago