Hi ,

How are you?

You know those problems that look boring at first but turn out oddly satisfying to solve? That’s exactly what this week’s video is about.

Imagine you have Sales, COGS, Operating Expenses, and HR Expenses… and you need extra columns showing each as a percentage of Sales. Doing it manually is painful, and if new expense columns appear you’d have to start over.

With List.Accumulate, you can make it dynamic, so all those percentage columns get created automatically. Add a new expense column, and the percentages update themselves. Watch the video here.



Check Data Quality in Power Query

Bad data = bad insights. Nobody wants to spend hours building a report only to realise the numbers are wrong.

This PDF walks you through quick ways to spot errors, nulls, duplicates, and patterns in using built-in tools in PQ.

Download the PDF.

A Nifty M Trick to Fill Right in Power Query

You probably know about Fill Down in Power Query, but what if you need to fill values to the right instead?

Here’s a short M code snippet that does exactly that. Super handy when your data has gaps across columns.

A Handy Trick to Auto-Refresh Data in Excel

Here’s a quick way to keep your Excel data fresh without clicking refresh again and again.

Currently reading - Tiny Experiments by Anne-Laure Le Cunff.
The book talks about how to live more freely in a world that’s always chasing goals. It feels like a refreshing perspective and is making me rethink how I look at progress.

It’s been raining cats and dogs. The humidity is so high that even the sand in my hourglass decided to stop flowing