Loading...

Finding the Date of the Next Record in Power Query

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) [...]

Read More »

Published on:

Learn more
Power BI Live Training - Power BI Online Training - Excelerator BI
Power BI Live Training - Power BI Online Training - Excelerator BI

Australian Power BI training ✅ Power BI online training ✅ Learn Power Query online ✅ Power BI expert, Matt Allington (MVP) ✅ Best in class Power BI book

Share post:

Related posts

Everything About Embedding Power BI into Dynamics 365 

Are you still struggling with managing and analyzing large datasets—like 1000 records or more—within CRM systems? Then no more. We have encoun...

1 day ago

Viva Insights: New Power BI report for Microsoft 365 Copilot agent metrics

Microsoft Viva Insights introduces a new Power BI report for Microsoft 365 Copilot declarative agents, providing leaders and admins with adopt...

1 day ago

Power BI Pro Trick: Sort Visuals by Fields NOT on the Chart!

Specific client requirements sometimes may force us to think out of the box and find not-so-obvious solutions The post Power BI Pro Trick: Sor...

1 day ago

Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature

Power Query gives you the capability of joining (merging) tables together using key columns, and there are multiple types of Merge types to ch...

4 days ago

Power BI Copilot, AI Instructions And DAX Query Templates

At the end of my last post I showed how, if you put the definition of a measure in the AI Instructions of your Power BI semantic model, Copilo...

6 days ago

Five Minutes to Wow: What vibe coding and Power BI reports have in common

In this article, I reflect on the subjective similarities between using AI-assistive coding tools to make software and using Tableau and Powe...

8 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy