Charity Data Geek

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...

Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...

I couldn't find a direct answer to this question, so thought, once I'd managed to piece it together I'd post it here for any fut...