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 Report Demo in Power BI Colors ✌️😅
13 hours ago
Convert tabular data to crosstab – Power Query
Convert tabular data to crosstab – Power Query. Let us understand this simple but useful task in Microsoft Excel. Download sample file R...
2 days ago
How to Rebind a Power BI Report to a different Semantic Model using Power BI Studio
The default option to rebind a Power BI report is to use the Power BI REST API. This works well, but for a lot of people this can be quite int...
3 days ago