Power Query - Build a Workflow Status Tracker in One Query 👑

File https://github.com/jbotes/powerbiTuto... #data #dataanalysis #mquery #powerbi #excel #powerqueryeditor In this tutorial, I'll show you how to summarise process data and build a complete workflow tracker using just one Table.Group(). By the end of the video, you'll be able to automatically calculate: ✅ Current Stage ✅ Next Stage ✅ Progress Percentage ✅ Overall Status (Not Started, In Progress, Completed) Whether you're tracking cases, approvals, projects, tickets, customer journeys, onboarding processes, or manufacturing workflows, this technique can be adapted to almost any sequential process. 💡 In this video you'll learn: • 📊 How to group records by Case ID • 🔍 How to find the current stage in a workflow • ➡️ How to identify the next stage automatically • 📈 How to calculate completion percentages • ⚡ How to combine multiple calculations into a single Table.Group() • 🧹 Tips for writing cleaner, more efficient Power Query (M) code This is a practical Power Query pattern that you can reuse in many real-world reporting and dashboard projects.