Charity Data Geek

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

I've had an iPad for over a decade and always found it's keyboard, particularly the lack of backwards and forwards keys, frustrating...

Often you have a lot of files in a folder and for some reason you want to paste them in Word, Excel, Notepad or something else, but a straig...

Say you run a series of events and want to display registration, attendance etc on a bar chart in Power BI. The length of the event names an...