Search
  • Doug Burke Data

Power Query (M)agic: Right-Click Your Way To Data Cleaning Happiness

Updated: Jun 20, 2018

Here is a post I created for my friends at Power Pivot Pro.

I hope you find it useful.

If you’re like me, you get crappy data from your source systems. Not that the data is inaccurate. No. It’s just that the data does not fit your view of the world. It doesn’t suit your needs right out of the box. That makes it crappy.

You need to clean it to make it usable. You need the ‘power’ of Power Query to turn night into day.

Did you know that Power Query’s most potent data cleanups are just a right-click away? Let me share the secret.