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
Microsoft Power BI & Fabric Licensing | Part 01
15 hours ago
Convert rows to columns using Power Query – Excel and Power BI
If you get data in a single column with multiple records, you can easily convert it to multiple columns using Power Query. Watch and Try with ...
2 days ago
SWITCH between TIME SLICERS in Power BI
2 days ago
Creating [DAX] SVG Charts using Chat GPT!
4 days ago