Charity Data Geek

The grid function in PowerBI is woeful. Mine currently doesn't work and I haven't even bothered to investigate it because it's s...

I got asked a question the other day about data cleansing from a relatively small organisation, who is wondering about whether or not to use...

Back in 2022 I wrote a post detailing the various ways you can replace part of a string in M code (Power Query). It's actually the post...

1. LTV & Attrition - see folder in "Other Favourites" for this 2. Infographics on Power BI 3. Using AltQ in PowerPoint etc. fo...

This is a post I wrote specifically to support my entry to the Storytelling With Data's community monthly challenge for June, which is t...

If you're familiar with Excel before moving to Power Query then it's a little maddening to find that PowerQuery doesn't have a b...

↑ This is a temporary one and not designed to be viewed large as the lines are a bit wobbly. But I couldn't find a better one out...

If you've ever imported data from a US supplier into a (UK) spreadsheet you may have found that the dates and times have gone wrong in E...

Back October I showed how to run a quick sum of a column in Power Query. But I curious to know how I could see this total alongside a count...

If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...